Identifying The DDL From The System Tables

Database
Enthusiast

Identifying The DDL From The System Tables

Hi all,

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 !

2 REPLIES
Teradata Employee

Re: Identifying The DDL From The System Tables

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.

Regards, Adeel

Enthusiast

Re: Identifying The DDL From The System Tables

Thanks Adeel