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.