SHOW MATERIALIZED VIEWS

You can list all materialized views in the current database or in another database.

Syntax

SHOW MATERIALIZED VIEWS [IN db_name];

db_name: The database name.

Examples

SHOW MATERIALIZED VIEWS;

+-----------------+--------------------+-----------------+
|     mv_name     |  rewrite_enabled   |      mode       |
+-----------------+--------------------+-----------------+
| # MV Name       | Rewriting Enabled  | Mode            |
| partition_mv_1  | Yes                | Manual refresh  |
| partition_mv_2  | Yes                | Manual refresh  |
| partition_mv_3  | Yes                | Manual refresh  |
|                 | NULL               | NULL            |
+-----------------+--------------------+-----------------+