Skip to main content
Skip to main content

CANCEL-MATERIALIZED-VIEW-TASK

CANCEL-MATERIALIZED-VIEW-TASK

Name

CANCEL MATERIALIZED VIEW TASK

Description

This statement is used to cancel the task of materialized views

syntax:

CANCEL MATERIALIZED VIEW TASK taskId=INTEGER_VALUE ON mvName=multipartIdentifier

Example

  1. Cancel the task with id 1 in materialized view mv1

    CANCEL MATERIALIZED VIEW TASK 1 on mv1;

Keywords

CANCEL, MATERIALIZED, VIEW, TASK

Best Practice