Cloud Computing

5) 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;

Similar Posts

Leave a Reply

Your email address will not be published. Required fields are marked *