DROP VIEW

DROP VIEW [ IF EXISTS ] view_identifier

-- 创建基础表和视图
CREATE EXTERNAL TABLE base_view_table (id INT, name STRING)
    USING PARQUET LOCATION 'cosn://<your_bucket_name>/test_drop_view/base';
CREATE VIEW drop_v1 AS SELECT * FROM base_view_table;

-- 删除视图
DROP VIEW drop_v1;

-- DROP 不存在的视图（预期失败：视图不存在）
DROP VIEW nonexistent_view_xyz;

-- IF EXISTS（不存在不报错）
DROP VIEW IF EXISTS nonexistent_view_xyz;

-- 带数据库前缀
CREATE DATABASE drop_view_db;
CREATE EXTERNAL TABLE drop_view_db.t1 (id INT) USING PARQUET
    LOCATION 'cosn://<your_bucket_name>/test_drop_view/db_t1';
CREATE VIEW drop_view_db.v1 AS SELECT * FROM drop_view_db.t1;
DROP VIEW drop_view_db.v1;