You use DROP VIEW to delete the definition of a view.
When a view definition is deleted, all the table and column privileges for this view are revoked from the current authorization identifier. Table and column privileges of the view that have been passed on are also revoked.
The VIEWS view of the INFORMATION_SCHEMA provides you with information on which views have been defined. Information on the tables a view uses is provided in the view VIEW_TABLE_USAGE (see chapter "Information schemas").
The current authorization identifier must own the schema to which the view belongs.
DROP VIEW table { CASCADE | RESTRICT }
table
Name of the view to be deleted.
CASCADE
The table view and all views and routines which refer directly or indirectly to table are deleted.
RESTRICT
The deletion of the view table is restricted. The view cannot be deleted if it is used in another view definition or in a routine.
See also
CREATE VIEW