Database DDL

General
Tourist

Database DDL

Hi,

 

Does anybody know where database DDL is stored similar to DBC.TablesV.RequestText?

Alternatively can it be quickly generated similar to SHOW DB.TABLE?

 

We have tried

1. Teradata Administrator (does not display database DDL)

2. Teradata Studio Administration (generates DDL but does not show how it is done therefore cannot be automated)

3. Various DBC tables and views

 

Thanks

 

Blofeld

 

1 REPLY 1
Ambassador

Re: Database DDL

Hi,

I don't think it is stored anywhere in the dbms.

You'll probably need to extract the data from dbc.dbase (or dbc.databasesv).

Cheers,

Dave

Ward Analytics Ltd - information in motion
www: http://www.ward-analytics.com