DROP VIEW Statement (drop_view_statement) 

The DROP VIEW statement (drop_view_statement) drops a view table.

Syntax

<drop_view_statement> ::= DROP VIEW <table_name> [<cascade_option>]

Examples

SQL Tutorial, View Tables

Explanation

The table name must identify an existing view table.

The user must be the owner of the specified view table or have the DROPIN privilege for the schema to which the view table is assigned.

The metadata of the view table and all dependent synonyms, view tables, and privileges are dropped. The tables on which the view table was created remain unaffected.

<cascade_option>

If no CASCADE option is specified, the view table is dropped together with all the view tables, privileges, and synonyms that are dependent on it.

·        If the CASCADE option RESTRICT is specified and other view tables or synonyms based on this view table exist, the drop view statement fails.

·        If the CASCADE option CASCADE is specified, the view table is dropped together with all the view tables, privileges, and synonyms that are dependent on it.