Modifying Schema, View, Table, and Routine Definitions › Maintaining Views › Dropping a View

Dropping a View

DROP VIEW Statement

To drop a view, use the SQL DDL DROP VIEW statement.

CASCADE Option

Use the CASCADE option if the view being dropped participates in any other view definitions. CASCADE directs CA IDMS/DB to drop the named view and all views derived from the named view.

When you drop a view (without CASCADE), the following definitions are removed from the dictionary:

• The view
• All privileges granted on the view

If you specify CASCADE, these additional definitions are removed from the dictionary:

• All views in which the view is referenced and all views referencing those views
• All privileges granted on views dropped as a result of cascade processing

Considerations

You must specify CASCADE if there are views defined on the view you are dropping.

Example

In the following example, the view EMP_HOME_INFO is dropped. This also drops any views derived from this view.

drop view emp_home_info cascade;