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