重要

你正在查看 TiDB 数据库的较旧版本 (TiDB v5.2) 的文档。

如无特殊需求,建议使用 TiDB 数据库的最新 LTS 版本

DROP VIEW

DROP VIEW 语句用于从当前所选定的数据库中删除视图对象。视图所引用的基表不受影响。

语法图

DropViewStmt
DROPVIEWIFEXISTSTableNameListRestrictOrCascadeOpt
TableNameList
TableName,
TableName
Identifier.Identifier

示例

CREATE TABLE t1 (id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, c1 INT NOT NULL);
Query OK, 0 rows affected (0.11 sec)
INSERT INTO t1 (c1) VALUES (1),(2),(3),(4),(5);
Query OK, 5 rows affected (0.03 sec)
Records: 5  Duplicates: 0  Warnings: 0
CREATE VIEW v1 AS SELECT * FROM t1 WHERE c1 > 2;
Query OK, 0 rows affected (0.11 sec)
SELECT * FROM t1;
+----+----+
| id | c1 |
+----+----+
|  1 |  1 |
|  2 |  2 |
|  3 |  3 |
|  4 |  4 |
|  5 |  5 |
+----+----+
5 rows in set (0.00 sec)
SELECT * FROM v1;
+----+----+
| id | c1 |
+----+----+
|  3 |  3 |
|  4 |  4 |
|  5 |  5 |
+----+----+
3 rows in set (0.00 sec)
DROP VIEW v1;
Query OK, 0 rows affected (0.23 sec)
SELECT * FROM t1;
+----+----+
| id | c1 |
+----+----+
|  1 |  1 |
|  2 |  2 |
|  3 |  3 |
|  4 |  4 |
|  5 |  5 |
+----+----+
5 rows in set (0.00 sec)

MySQL 兼容性

DROP VIEW 语句与 MySQL 完全兼容。如发现任何兼容性差异,请在 GitHub 上提交 issue

See also

文档内容是否有帮助?