Skip to main content
Version: Stable-3.1

CANCEL REFRESH MATERIALIZED VIEW

Description

Cancels a refresh task for an asynchronous materialized view.

tip

This operation requires the REFRESH privilege on the target materialized view.

Syntax

CANCEL REFRESH MATERIALIZED VIEW [<database_name>.]<materialized_view_name>

Parameters

ParameterRequiredDescription
database_nameNoName of the database where the materialized view resides. If this parameter is not specified, the current database is used.
materialized_view_nameYesName of the materialized view.

Examples

Example 1: Cancel the refresh task for the ASYNC refresh materialized view lo_mv1.

CANCEL REFRESH MATERIALIZED VIEW lo_mv1;