This statement is used to drop a materialized view. Synchronous syntax

    grammar:

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

    3. table_name: The name of the table to which the materialized view to be deleted belongs. Required.

    The table structure is

    2. +----------------+-------+----------+------+------ -+---------+-------+
    3. | IndexName | Field | Type | Null | Key | Default | Extra |
    4. +----------------+-------+----------+------+------ -+---------+-------+
    5. | | k2 | SMALLINT | Yes | false | N/A | NONE |
    6. | | k3 | INT | Yes | false | N/A | NONE |
    7. | | k4 | BIGINT | Yes | false | N/A | NONE |
    8. | | k5 | LARGEINT | Yes | false | N/A | NONE |
    10. | | k7 | DOUBLE | Yes | false | N/A | NONE |
    11. | | | | | | | | |
    12. | k1_sumk2 | k1 | TINYINT | Yes | true | N/A | |
    13. | | k2 | SMALLINT | Yes | false | N/A | SUM |
    14. +----------------+-------+----------+------+------ -+---------+-------+

    1. Drop the materialized view named k1_sumk2 of the table all_type_table

      1. +----------------+-------+----------+------+------ -+---------+-------+
      2. +----------------+-------+----------+------+------ -+---------+-------+
      4. | | k2 | SMALLINT | Yes | false | N/A | NONE |
      5. | | k3 | INT | Yes | false | N/A | NONE |
      6. | | k4 | BIGINT | Yes | false | N/A | NONE |
      7. | | k5 | LARGEINT | Yes | false | N/A | NONE |
      8. | | k6 | FLOAT | Yes | false | N/A | NONE |
      9. | | k7 | DOUBLE | Yes | false | N/A | NONE |
      10. +----------------+-------+----------+------+------ -+---------+-------+

    2. Drop a non-existent materialized view in the table all_type_table

      The delete request reports an error directly

    3. Delete the materialized view k1_k2 in the table all_type_table, if it does not exist, no error will be reported.

      1. drop materialized view if exists k1_k2 on all_type_table;