> ## Documentation Index
> Fetch the complete documentation index at: https://docs.risingwave.com/llms.txt
> Use this file to discover all available pages before exploring further.

# 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](/sql/system-catalogs/rw-catalog#available-risingwave-catalogs) table to display internal table information. This is useful when you need to join internal table information with other data.

## Syntax

```sql theme={null}
SHOW INTERNAL TABLES [ FROM schema_name ] [ LIKE_expression ];
```

## Parameters

| Parameter        | Description                                                                                                                                                                                                                                                                                                                        |
| :--------------- | :--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| *schema\_name*   | The schema in which tables will be listed. If not specified, tables from all schemas in the current schema [search\_path](https://docs.risingwave.com/operate/view-configure-runtime-parameters#how-to-view-runtime-parameters:~:text=multi%20point%20lookup.-,search_path,-%E2%80%9D%24user%E2%80%9D%2C%20public) will be listed. |
| LIKE\_expression | Filters the output based on names by applying pattern matching. See details in [LIKE pattern matching expressions](/sql/functions/string#like-pattern-matching-expressions).                                                                                                                                                       |

## Example

```bash theme={null}
SHOW INTERNAL TABLES;
                   Name
------------------------------------------
 public.__internal_v_20_hashjoinright_1019
 public.__internal_v_20_hashjoindegreeleft_1018
 public.__internal_v_18_grouptopnnode_1011
 public.__internal_v_20_hashjoindegreeright_1020
 public.__internal_v_17_topnnode_1010
 public.__internal_v_19_hashjoindegreeleft_1014
 public.__internal_v_20_hashjoinleft_1017
 public.__internal_v_18_hashaggresult_1012
 public.__internal_v_19_hashjoinright_1015
 public.__internal_v_19_hashjoindegreeright_1016
 public.__internal_v_19_hashjoinleft_1013
(11 rows)
```

You can view the data in an internal table:

```sql theme={null}
SELECT * FROM __internal_v_19_hashjoinleft_1013 LIMIT 5;

 orders.o_orderkey | orders.o_orderdate | orders.o_shippriority | customer.c_custkey | orders.o_custkey
-------------------+--------------------+-----------------------+--------------------+------------------
                69 | 1994-06-04         |                     0 |                 85 |               85
               256 | 1993-10-19         |                     0 |                125 |              125
              1154 | 1992-02-15         |                     0 |                 37 |               37
              1792 | 1993-11-09         |                     0 |                 49 |               49
              1894 | 1992-03-30         |                     0 |                 76 |               76
(5 rows)
```

<Note>
  Starting from v2.7.0, the `Name` column in the output includes the schema name as a prefix (e.g., `public.__internal_table_name`). This helps distinguish internal tables with the same name in different schemas when querying across multiple schemas in the search path.
</Note>