To view every column and the columns contained in indexes in Teradata

Using the following query each column can be described in the Teradata RDBMS
SELECT * FROM DBC.TVFields;


To view the columns contained in indexes in the Teradata RDBMS, you can render the following query
SELECT * FROM DBC.Indexes;