DROP VIEW

The DROP VIEW data description statement deletes the definition of a view from the dictionary.
idmscu19
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. 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.
More information
  • For more information about defining a view, see CREATE VIEW.