PreviousSQL Engine Reference (v9 SP2 (9.5) revision 1) Next

DROP VIEW

Chapter contents

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


Chapter contents
Book contents

Prev topic: DROP USER
Next topic: END