How to find some of the table properties in Datadictionary?

Database
Enthusiast

How to find some of the table properties in Datadictionary?

Are there any dbc views that I can query to find the properties of a table like CHECKSUM, DATABLOCKSIZE and FREESPACE. I am able to see these properties in the "show table" but not able to find the Table/View where it is stored (In Datadictionary). Can any one help me out in this?
Thanks,
Manu.
1 REPLY
Junior Contributor

Re: How to find some of the table properties in Datadictionary?

Hi Manu,
those options are not stored anywhere within the data dictionary, it's within the table header.

Using SQL the only way to get that info is a SHOW TABLE.

Dieter