SHOW OBJECTS
SHOW OBJECTS returns a list of all objects in Materialize for a given schema.
Objects include tables, sources, sinks, views, materialized views, indexes,
secrets and connections.
Syntax
| Field | Use |
|---|---|
| schema_name | The schema to show objects from. Defaults to first resolvable schema in the search path. For available schemas, see SHOW SCHEMAS. |
Details
Output format
SHOW OBJECTS will output a table with two columns, nameand 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