Commands
SHOW TABLES
The SHOW TABLES command returns a list of views or tables created within a schema.
Lists the views or tables for which you have access privileges. You can use this command to list views or tables in the current schema or a specified schema.
The output includes table metadata and properties, ordered lexicographically by schema and table name.
Syntax
SHOW TABLES;
Output
The command output provides table properties and metadata in the following columns:
| Column | Description |
|---|---|
TABLE_SCHEMA | Schema that contains the table or view. |
TABLE_NAME | Name of the table or view. |
Usage notes
SHOW TABLESlists tables and views that the current user is authorized to access.- The command returns objects from the current schema by default. If a schema is specified, only tables and views in that schema are returned.
- Results include both base tables and views. Use the output metadata to distinguish between object types.
- This command does not list files or filesystem objects. To list files, use the
SHOW FILEScommand. - The output is ordered lexicographically by schema name and table name. When applying filters to the results, be aware that filters operate on this ordered output.
- Only metadata for accessible objects is returned. Tables or views that exist but are not visible to the current user are not included.
- The metadata and properties returned reflect the current state of each object at the time the command is executed.
We’re actively preparing more detailed documentation and will be adding it here shortly.