This command removes a view.
Syntax
DROP VIEW view_name ;
| Keyword |
Description |
|
view_name
|
Name of the view to remove |
Use
This statement drops a view, which must have been created previously with a CREATE VIEW statement. To drop a view, you must
own the schema within which the view resides or have database administrator privileges.
Example
DROP VIEW STAFF_VIEW