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)