Materialize Logo

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

SHOW EXTENDED FULL OBJECTS FROM schema_name
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
Did this info help?
Yes No