Developer Reference
:
Data Access Methods
:
SQL Engine Reference
:
SQL Syntax Reference
: DROP VIEW
DROP VIEW
This statement removes a specified view from the database.
Syntax
DROP VIEW
[
IF EXISTS
]
view-name
view-name
::=
user-defined name
Remarks
[
CASCADE
|
RESTRICT
] is not supported.
The expression IF EXISTS causes the statement to return success instead of an error if a view does not exist. IF EXISTS does not suppress other errors.
Examples
The following statement drops the vw_person view definition from the dictionary.
DROP VIEW vw_person
See Also
CREATE VIEW
This site works best with JavaScript enabled