I know that the complete DDL information for a table can be obtained using the show table command, however i
am intrested in knowing where these table,column index info are stored in the system tables for example the datablocksize,
freespace , column is casespecifc , not null etc basically i would like to trace the entire info available in the show table through
the system tables .
Please help !
I wrote something in 2008 .... which am attaching here .... hope that helps.
As far as i know, you cannot come up with 100% identical output as that of SHOW TABLE command, but it might just fulfills what you are trying to achieve.