SHOW is a command used to display the list of Schemas, Tables, or Columns of the table.
Syntax
Following is the generic syntax of the SHOW command.
SHOW { SCHEMAS | TABLES [ FROM schemaName ] |
COLUMNS FROM tableName [ FROM schemaName ] }
Example
The following command can be used to get the list of tables in the current database.
SHOW TABLES;
The above command produces the following output.
| TABLE_NAME | TABLE_SCHEMA |
| CUSTOMER | PUBLIC |
| EMP | PUBLIC |
