Description

List existing objects of the specified object type.

Syntax

SHOW <object_type_plural> [ LIKE '<pattern>' | WHERE <expr>] [ IN <scope_object_type> ]

• The optional parameter WHERE <expr> allows users to filter the displayed fields based on the command. Users can filter the results through expressions to more accurately find the required database objects. Currently, only TABLE, TABLE STREAM, CONNECTIONS, VCLUSTERS, and JOBS objects are supported.

Specific Syntax Reference

SHOW USERS

SHOW GRANTS

SHOW ROLES

SHOW GRANTS

SHOW CONNECTIONS

SHOW SCHEMAS

View External SCHEMA

SHOW SHARES

SHOW VCLUSTERS

SHOW JOBS

SHOW DYNAMIC TABLE REFRESH HISTORY

SHOW TABLES

SHOW PARTITIONS

SHOW VIEWS

List Materialized Views in the Current Space

List Dynamic Tables

SHOW INDEX

SHOW TABLE STREAMS

SHOW SYNONYMS