Displays the attributes for the primary and secondary indexes defined for a base data table or join index.
HELP INDEX does not display the attributes for hash or join indexes. See HELP JOIN INDEX for information about how to report the attributes for join indexes.
Also see the following sections:
ANSI Compliance
This statement is a Teradata extension to the ANSI SQL:2011 standard.
Required Privileges
You must either own the table or join index on which the index is defined or have at least one privilege on that table or join index.
The SHOW privilege enables a user to perform HELP or SHOW requests only against a specified index.