Displays the attributes of a column, including whether it is a single-column primary or secondary index and, if so, whether it is unique.
ANSI Compliance
This statement is a Teradata extension to the ANSI SQL:2011 standard.
Required Privileges
You must either own the table, join index, or hash index in which the column is defined or have at least one privilege on that table.
Use the SHOW privilege to enable a user to perform HELP or SHOW requests only against a specified table, join index, or hash index.