SHOW TABLES
NOTE!
For improved performance, execute this command in the
mz_introspection cluster. To switch clusters, use SET CLUSTER = mz_introspection;.
SHOW TABLES returns a list of all tables available to your Materialize instances.
Syntax
| Field | Use |
|---|---|
| schema_name | The schema to show tables from. Defaults to public in the current database. For available schemas, see SHOW SCHEMAS. |
Details
Output format
SHOW TABLES’s output is a table with one column, name.
Examples
Show user-created tables
SHOW TABLES;
name
----------------
my_table
my_other_table
Show tables from specified schema
SHOW SCHEMAS;
name
--------
public
SHOW TABLES FROM public;
name
----------------
my_table
my_other_table