DROP MATERIALIZED VIEW

      1. IF EXISTS If the materialized view does not exist, doris will not throw an error. If this keyword is not declared, an error will be reported if the materialized view does not exist. Ranch

      2. mv_name The name of the materialized view to be deleted. Required.

      3. Table_name Name of the table to which the materialized view to be deleted belongs. Required.

      +————————+———-+—————+———+———-+————-+———-+ | IndexName | Field | Type | Null | Key | Default | Extra | +————————+———-+—————+———+———-+————-+———-+ | all_type_table | k1 | TINYINT | Yes | true | N/A | | | | k2 | SMALLINT | Yes | false | N/A | NONE | | | k3 | INT | Yes | false | N/A | NONE | | | k4 | BIGINT | Yes | false | N/A | NONE | | | k5 | LARGEINT | Yes | false | N/A | NONE | | | k6 | FLOAT | Yes | false | N/A | NONE | | | k7 | DOUBLE | Yes | false | N/A | NONE | +————————+———-+—————+———+———-+————-+———-+ ```

      ERROR 1064 (HY000): errCode = 2, detailMessage = Materialized view [k1_k2] does not exist in table [all_type_table] ```

      Query OK, 0 rows affected (0.00 sec) ```