Monday 10 March 2014

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