首页 项目目录 关于我们
Sign In
rust
/
Materialize
1
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Tree: 6dd8e59864
Branches Tags
Materialize
/
doc
/
user
/
content
/
sql
/
show-objects.md

show-objects.md 1.5 KB
History Raw

title: "SHOW OBJECTS" description: "SHOW OBJECTS returns a list of all objects in Materialize for a given schema." menu: main:

parent: commands

aliases:

- /sql/show-object

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> ]

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

Related pages

Option Description
FROM If specified, only show objects from the specified schema. Defaults to first resolvable schema in the search path. For available schemas, see SHOW SCHEMAS.