Commands
SHOW INTERNAL TABLES
Use the SHOW INTERNAL TABLES
command to view the existing internal tables in RisingWave. Internal tables are tables that store intermediate results (also known as internal states) of queries.
In addition to SHOW INTERNAL TABLES
, you can also use the rw_internal_tables table to display internal table information. This is useful when you need to join internal table information with other data.
Syntax
Parameters
Parameter | Description |
---|---|
schema_name | The schema in which tables will be listed. If not given, tables from the default schema, public, will be listed. |
LIKE_expression | Filters the output based on names by applying pattern matching. See details in LIKE pattern matching expressions. |
Example
You can view the data in an internal table:
Was this page helpful?