SHOW MATERIALIZED VIEWS
You can list all materialized views in the current database or in another database. You can filter a list of materialized views in a specified database using regular expression wildcards.
Syntax
SHOW MATERIALIZED VIEWS [IN db_name];- db_name
- The database name.
- 'identifier_with_wildcards'
- The name of the materialized view or a regular expression consisting of part of the name plus wildcards. The asterisk and pipe (* and |) wildcards are supported. Use single quotation marks to enclose the identifier.
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 |
+-----------------+--------------------+-----------------+SHOW MATERIALIZED VIEWS '*1';
+-----------------+--------------------+-----------------+
| mv_name | rewrite_enabled | mode |
+-----------------+--------------------+-----------------+
| # MV Name | Rewriting Enabled | Mode |
| partition_mv_1 | Yes | Manual refresh |
| | NULL | NULL |
+-----------------+--------------------+-----------------+ 