DROP VIEW

The DROP VIEW data description statement deletes the definition of a view from the dictionary.

Authorization

To issue a DROP VIEW statement, you must own or have the DROP privilege on the view named in the statement.

Note: You need no additional privileges to issue a DROP VIEW statement with the CASCADE parameter.

Syntax

►►─── DROP VIEW ─┬────────────────┬─ view-identifier ─────────────────────────►
                 └─ schema-name. ─┘

 ►─┬───────────┬──────────────────────────────────────────────────────────────►◄
   └─ CASCADE ─┘

Parameters

view-identifier

Specifies the name of the view being dropped. View-identifier must identify a view defined in the dictionary.

schema-name

Identifies the schema associated with the named view.

If you do not specify a schema-name, the default value is:

The current schema associated with your SQL session, if the statement is entered through the Command Facility or executed dynamically
The schema associated with the access module used at runtime, if the statement is embedded in an application program

CASCADE

Directs CA IDMS to delete the definitions of all views derived from the named view.

Example

Dropping a View

The following DROP VIEW statement deletes the definitions of the EMP_VACATION view and all views derived from the EMP_VACATION view:

drop view emp_vacation cascade;

Views that Participate in Other Views

If you do not specify CASCADE in a DROP VIEW statement, the view named in the statement cannot participate in the definition of any other view.

Note: For more information about defining a view, see CREATE VIEW