PROVE IT !!If you know it then PROVE IT !! Skill Proficiency Test

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

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;

Add a Comment

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