Show materialized views
You can list all or a filtered list of materialized views in all databases or a specific database.
- Asterisk (*)
Represents one or more characters.
- Pipe symbol (|)
Represents a choice.
For example, mv_q* and *mv|q1* match the materialized view mv_q1. Finding no match does not cause an error.
List materialized views in the current database.
SHOW MATERIALIZED VIEWS;
List materialized views in a particular database.
SHOW MATERIALIZED VIEWS IN my_database;
Show materialized views having names that begin with mv.
SHOW MATERAILIZED VIEWS mv*