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?

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;