Wednesday, August 8, 2012


How to view every column and the columns contained in indexes in Teradata?

How to view every column and the columns contained in indexes in Teradata?

Answers:
Following query describes each column in the Teradata RDBMS
SELECT * FROM DBC.TVFields;

Following query describes columns contained in indexes in the Teradata RDBMS
SELECT * FROM DBC.Indexes;

No comments:

Post a Comment

Thank you :
- kareem