SHOW has many forms that provide information about databases, tables, columns, or status information about the server.
The following table provides an overview of the SHOW statements that can be used with the ODBC driver.
| Statement | Description |
|---|---|
| SHOW COLUMNS | Lists columns in a specified table. |
| SHOW CREATE DATABASE | Shows the CREATE DATABASE statement for a database. |
| SHOW CREATE EVENT | Shows the CREATE EVENT statement. |
| SHOW CREATE FUNCTION | Shows the CREATE FUNCTION statement. |
| SHOW CREATE PROCEDURE | Shows the CREATE PROCEDURE statement. |
| SHOW CREATE SCHEMA | Synonym for SHOW CREATE DATABASE. |
| SHOW CREATE TABLE | Shows the CREATE TABLE statement for a table. |
| SHOW CREATE TRIGGER | Shows the CREATE TRIGGER statement. |
| SHOW CREATE USER | Shows the CREATE USER statement for a user. |
| SHOW CREATE VIEW | Shows the CREATE VIEW statement for a view. |
| SHOW DATABASES | Lists all databases on the MySQL server. |
| SHOW ENGINE | Provides operational details about a storage engine. |
| SHOW FIELDS | Synonym for SHOW COLUMNS. |
| SHOW FUNCTION STATUS | Lists stored functions. |
| SHOW INDEX | Shows indexes for a table. |
| SHOW INDEXES FROM | Synonym for SHOW INDEX FROM. |
| SHOW KEYS | Synonym for SHOW INDEX. |
| SHOW KEYS FROM | Synonym for SHOW INDEX FROM. |
| SHOW PRIVILEGES | Lists supported privilege types. |
| SHOW PROCEDURE STATUS | Lists stored procedures. |
| SHOW SCHEMAS | Synonym for SHOW DATABASES. |
| SHOW TABLES | Lists tables in a database. |