DROP VIEW

---

This statement removes a specified view from the database.

Syntax

DROP VIEW view-name 

Remarks

[CASCADE | RESTRICT] is not supported.

Examples

The following statement drops the vw_person view definition from the dictionary.

DROP VIEW vw_person 

See Also

CREATE VIEW