Displays the attributes of a column, including whether it is a single-column primary or secondary index and, if so, whether it is unique.
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.