Description

This command is used to view information about all Table Streams under the current database schema. Table Streams are a type of real-time data stream that allows you to perform real-time analysis and processing of data in the table.

Syntax

SHOW TABLE STREAMS [IN schema_name] [LIKE 'pattern' | WHERE expr]

Parameter Description

1. IN schema_name (optional): Specifies the schema name to view. If not specified, the default schema of the current user is viewed.
2. LIKE pattern (optional): Filters the command output by object name using case-insensitive pattern matching. Supports SQL wildcards (% and _). Note: Cannot be used with the WHERE clause.
3. WHERE expr (optional): Supports filtering based on the fields displayed by show table streams.

Example

1. View all table streams under the current schema:

   SHOW TABLE STREAMS;

Result:

+-------------------------+-------------+--------------+------------+-------------+---------+ | create_time | schema_name | name | table_name | mode | comment | +-------------------------+-------------+--------------+------------+-------------+---------+ | 2023-11-24 21:44:07.261 | public | event_stream | event | APPEND_ONLY | | +-------------------------+-------------+--------------+------------+-------------+---------+

2. View all table streams under the specified schema:

   SHOW TABLE STREAMS IN my_schema;

3. View the streams of tables under the current schema that contain "test" in their names:

   SHOW TABLE STREAMS LIKE '%test%';

4. View table streams that meet specific conditions with the WHERE clause:

   SHOW TABLE STREAMS WHERE mode = 'APPEND_ONLY';