How do you see a DDL for an existing table in Teradata?
By using show table command as follows
show table tablename ;
This will display DDL structure of table along with following details
Fallback
Before/after journal
set/multiset table type
Index(PI,SI,PPI)
details about column - datatype ,default,identity/primary -foreign key .
No comments:
Post a Comment