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

SHOW TABLES FROM schema_name
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
Back to top ↑