Tuesday, February 15, 2011

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