Displays the attributes, sorted by object name, for all tables, views, join indexes, hash indexes, SQL procedures, user-defined functions, and macros contained by a specified database.
Privileges
You must either own the database or have at least one privilege on that database.
Use the SHOW privilege to enable a user to perform HELP or SHOW requests only against a specified database.