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. |
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