SHOW OBJECTS
NOTE!
For improved performance, execute this command in the
mz_introspection
cluster. To switch clusters, use SET CLUSTER = mz_introspection;
.
SHOW OBJECTS
returns a list of all objects available to your Materialize instances in a given schema.
Objects include tables, sources, sinks, views, indexes, secrets and connections.
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
will output a table with two columns, name
and type
.
Examples
SHOW SCHEMAS;
name
--------
public
SHOW OBJECTS FROM public;
name | type
----------------+-------
my_table | table
my_source | source
my_view | view
my_other_source | source
SHOW OBJECTS;
name | type
----------+-------
my_table | table
my_source | source
my_view | view