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.
Example
SHOW MATERIALIZED VIEWS IN mydb.mv1 'mv1|mv2|mv3';