SHOW OBJECTS
SHOW OBJECTS returns a list of all objects available to your Materialize instances in a given schema.
Objects include tables, sources, views, indexes, and sinks.
Syntax
| Field | Use |
|---|---|
| schema_name | The schema to show objects from. Defaults to public in the current database. For available schemas, see SHOW SCHEMAS. |
Details
Output format
SHOW OBJECTS’s output is a table with one column, name. SHOW FULL OBJECTS will output a table with
two columns, name and type. type indicates whether the object was created by the system or a user.
Examples
SHOW SCHEMAS;
public
SHOW OBJECTS FROM public;
my_table
my_source
my_sink
my_other_sink
SHOW OBJECTS;
my_table
my_source
my_sink
my_other_sink
SHOW FULL OBJECTS;
my_table user
my_source user
my_sink user
my_other_sink user
SHOW EXTENDED FULL OBJECTS;
my_table user
my_source user
my_sink user
my_other_sink user
builtin_view system