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;