SHOW TABLES

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`.
EXTENDED	Returns system tables as well as user-created tables. By default, only user-created tables are returned.
FULL	Returns a column that lists table type (`system`, `user`, or `temp`).

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 user-created tables

SHOW TABLES;

my_table
my_other_table

Show tables from specified schema

SHOW SCHEMAS;

public

SHOW TABLES FROM public;

my_table
my_other_table

Show all tables and include table type

EXTENDED lists system tables as well as user-created tables; FULL adds the type column that specifies whether the table was created by a user or a temp process or is a system table.

SHOW EXTENDED FULL TABLES;

name                  |  type
----------------------+--------
 mz_array_types       | system
 mz_avro_ocf_sinks    | system
 mz_base_types        | system
 ...
 my_table             | user
 my_other_table       | user
(23 rows)