📄️ ALTER MATERIALIZED VIEW
ALTER MATERIALIZED VIEW can:
📄️ CANCEL REFRESH MATERIALIZED VIEW
CANCEL REFRESH MATERIALIZED VIEW cancels a refresh task for an asynchronous materialized view.
📄️ CREATE MATERIALIZED VIEW
CREATE MATERIALIZED VIEW creates a materialized view. For usage information about materialized views, see Synchronous materialized view and Asynchronous materialized view.
📄️ DROP MATERIALIZED VIEW
DROP MATERIALIZED VIEW drops a materialized view.
📄️ REFRESH MATERIALIZED VIEW
REFRESH MATERIALIZED VIEW manually refreshes a specific asynchronous materialized view or partitions within.
📄️ SHOW ALTER MATERIALIZED VIEW
SHOW ALTER MATERIALIZED VIEW shows the building status of synchronous materialized views.
📄️ SHOW CREATE MATERIALIZED VIEW
SHOW CREATE MATERIALIZED VIEW shows the definition of a specific asynchronous materialized view.
📄️ SHOW MATERIALIZED VIEWS
SHOW MATERIALIZED VIEWS shows all or one specific asynchronous materialized view.