MySQL 5.0 Reference Manual :: 12 SQL Statement Syntax :: 12.1 Data Definition Statements :: 12.1.19 DROP VIEW Syntax
Section Navigation [Toggle]
- 12.1 Data Definition Statements
- 12.1.1 ALTER DATABASE Syntax
- 12.1.2 ALTER FUNCTION Syntax
- 12.1.3 ALTER PROCEDURE Syntax
- 12.1.4 ALTER TABLE Syntax
- 12.1.5 ALTER VIEW Syntax
- 12.1.6 CREATE DATABASE Syntax
- 12.1.7 CREATE FUNCTION Syntax
- 12.1.8 CREATE INDEX Syntax
- 12.1.9 CREATE PROCEDURE and CREATE FUNCTION Syntax
- 12.1.10 CREATE TABLE Syntax
- 12.1.11 CREATE TRIGGER Syntax
- 12.1.12 CREATE VIEW Syntax
- 12.1.13 DROP DATABASE Syntax
- 12.1.14 DROP FUNCTION Syntax
- 12.1.15 DROP INDEX Syntax
- 12.1.16 DROP PROCEDURE and DROP FUNCTION Syntax
- 12.1.17 DROP TABLE Syntax
- 12.1.18 DROP TRIGGER Syntax
- 12.1.19 DROP VIEW Syntax
- 12.1.20 RENAME TABLE Syntax
DROP VIEW [IF EXISTS]
view_name [, view_name] ...
[RESTRICT | CASCADE]
DROP VIEW removes one or more
views. You must have the DROP
privilege for each view. If any of the views named in the argument
list do not exist, MySQL returns an error indicating by name which
nonexisting views it was unable to drop, but it also drops all of
the views in the list that do exist.
The IF EXISTS clause prevents an error from
occurring for views that don't exist. When this clause is given, a
NOTE is generated for each nonexistent view.
See Section 12.4.5.37, “SHOW WARNINGS Syntax”.
RESTRICT and CASCADE, if
given, are parsed and ignored.
This statement was added in MySQL 5.0.1.
User Comments
Add your own comment.