MySQL 5.1 Reference Manual :: 12 SQL Statement Syntax :: 12.1 Data Definition Statements :: 12.1.31 DROP VIEW Syntax
Section Navigation [Toggle]
- 12.1 Data Definition Statements
- 12.1.1 ALTER DATABASE Syntax
- 12.1.2 ALTER EVENT Syntax
- 12.1.3 ALTER LOGFILE GROUP Syntax
- 12.1.4 ALTER FUNCTION Syntax
- 12.1.5 ALTER PROCEDURE Syntax
- 12.1.6 ALTER SERVER Syntax
- 12.1.7 ALTER TABLE Syntax
- 12.1.8 ALTER TABLESPACE Syntax
- 12.1.9 ALTER VIEW Syntax
- 12.1.10 CREATE DATABASE Syntax
- 12.1.11 CREATE EVENT Syntax
- 12.1.12 CREATE FUNCTION Syntax
- 12.1.13 CREATE INDEX Syntax
- 12.1.14 CREATE LOGFILE GROUP Syntax
- 12.1.15 CREATE PROCEDURE and CREATE FUNCTION Syntax
- 12.1.16 CREATE SERVER Syntax
- 12.1.17 CREATE TABLE Syntax
- 12.1.18 CREATE TABLESPACE Syntax
- 12.1.19 CREATE TRIGGER Syntax
- 12.1.20 CREATE VIEW Syntax
- 12.1.21 DROP DATABASE Syntax
- 12.1.22 DROP EVENT Syntax
- 12.1.23 DROP FUNCTION Syntax
- 12.1.24 DROP INDEX Syntax
- 12.1.25 DROP LOGFILE GROUP Syntax
- 12.1.26 DROP PROCEDURE and DROP FUNCTION Syntax
- 12.1.27 DROP SERVER Syntax
- 12.1.28 DROP TABLE Syntax
- 12.1.29 DROP TABLESPACE Syntax
- 12.1.30 DROP TRIGGER Syntax
- 12.1.31 DROP VIEW Syntax
- 12.1.32 RENAME DATABASE Syntax
- 12.1.33 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.42, “SHOW WARNINGS Syntax”.
RESTRICT and CASCADE, if
given, are parsed and ignored.
User Comments
Add your own comment.