8.1.9 The rpd_table_id Table

The rpd_table_id table provides the ID, name, and schema of the tables loaded in MySQL HeatWave.

The rpd_table_id table has these columns:

• ID

  A unique identifier for the table.

• NAME

  The full table name including the schema.

• SCHEMA_NAME

  The schema name.

• TABLE_NAME

  The table name.

• MATERIALIZATION_QUERY

  Available as of MySQL 9.3.0. The column contains the query used to create the MySQL HeatWave temporary table.

  As of MySQL 9.5.0, the column contains the query used to create the materialized view or the MySQL HeatWave temporary table.

The rpd_table_id table is read-only.