Oracle7 Server SQL Reference
DROP VIEW
Purpose
To remove a view from the database.
Prerequisites
The view must be in your own schema or you must have DROP ANY VIEW system privilege.
If you are using Trusted Oracle7 in DBMS MAC mode, your DBMS label must match the view's creation label or you must satisfy one of the following criteria:
- If the view's creation label is higher than your DBMS label, you must have READUP and WRITEUP system privileges
- If the view's creation label is lower than your DBMS label, you must have WRITEDOWN system privilege.
- If the view's creation label and your DBMS label are not comparable, you must have READUP, WRITEUP, and WRITEDOWN system privileges.
Syntax
Keywords and Parameters
schema is the schema containing the view. If you omit schema, Oracle7 assumes the view is in your own schema.
view
is the name of the view to be dropped.
Usage Notes
When you drop a view, views and synonyms that refer to the view are not dropped, but become invalid. Drop them or redefine them, or define other views in such a way that the invalid views and synonyms become valid again.
You can change the definition of a view by dropping and recreating it.
Example
The following statement drops the VIEW_DATA view:
DROP VIEW view_data
Related Topics
CREATE TABLE command
CREATE VIEW command
CREATE SYNONYM command