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
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).