SHOW TABLES
Use the SHOW TABLES
command to view tables in a particular schema.
Syntax
SHOW TABLES [ FROM schema_name ] [ LIKE_expression ];
Parameters
Parameter or clause | Description |
---|---|
schema_name | The schema in which tables will be listed. If not given, tables from the default schema, public , will be listed. |
LIKE_expression | Filters the output based on names by applying pattern matching. See details in LIKE pattern matching expressions. |
Example
SHOW TABLES FROM public LIKE 't_';
t1