How To View Every Column And The Columns Contained In Indexes In Tera

1.	How To View Every Column And The Columns Contained In Indexes In Teradata?
Answer» 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; Following query describes each column in the Teradata RDBMS Following query describes columns contained in indexes in the Teradata RDBMS

How To View Every Column And The Columns Contained In Indexes In Teradata?

Answer»

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;

Following query describes each column in the Teradata RDBMS

Following query describes columns contained in indexes in the Teradata RDBMS