August 2010
Intermediate to advanced
526 pages
23h 39m
English
DROP VIEW — Delete a view from a database

DROP VIEWdatabase_name.view_name;
The DROP
VIEW command removes a view from the database.
Although the view will no longer be available, none of the
referenced data is altered in any way. Dropping a view will also
remove any associated triggers.
Dropping a view that does not exist
will normally generate an error. If the optional IF EXISTS clause is provided,
this error is silently ignored.
Read now
Unlock full access