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
SHOW OBJECTS [ FROM <schema_name> ]
| Option | Description |
|---|---|
| FROM <schema_name> | If specified, only show objects from the specified schema. 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