Dropping a view

Procedure

  1. Log on to the NonStop SQL/MX Database Manager.
  2. In the navigation tree, navigate to Schemas folder by expanding Database > My Systems > Catalogs > Schemas.
  3. Expand the Views folder (left pane) or click the Views tab (right pane), and select the view you want to remove.
  4. Right-click and select Drop View.

    The Confirm Drop View dialog box appears.

  5. Select Restrict or Cascade, and click Yes.

    If you select Restrict, the view is not dropped if it is referenced from another view or from any other object.

    If you select Cascade, any dependent objects on the view are also dropped.