Materialize Logo

SHOW TABLES

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.
EXTENDED Returns system tables as well as user-created tables. By default, only user-created tables are returned.

Details

Output format

SHOW TABLES's output is a table with one column, name.

Changed in v0.5.0: The output column is renamed from TABLES to name.

Examples

SHOW SCHEMAS;
public
SHOW TABLES FROM public;
my_table
my_other_table
SHOW TABLES;
my_table
my_other_table
Did this info help?
Yes No