May 2005
Intermediate to advanced
352 pages
14h 39m
English
DROP VIEW
DROP VIEW [IF EXISTS] view[, . . . ] [RESTRICT|CASCADE]
Use this statement to delete a view.
The IF EXISTS flag prevents error messages if the
view doesn't exist before attempting to delete it.
To retrieve the error message when this flag is added, use the
SHOW WARNINGS statement. The
RESTRICT or CASCADE options are
for a future release of MySQL. This statement is available as of
Version 5.0.1 of MySQL.
Read now
Unlock full access