Dropping a sequence generator

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 Sequences folder (left pane) or click the Sequences tab (right pane), and select the sequence generator you want to remove.
  4. Right-click and select Drop Sequence.

    The Confirm Drop Sequence dialog box appears.

  5. Select Restrict or Cascade option.

    • If you select Restrict option and there are one or more triggers that reference the selected sequence generator, then the sequence is not dropped. And an error message is displayed.

    • If you select Cascade option and there are one or more triggers that reference the selected sequence generator, then the selected sequence generator and related triggers are dropped.

  6. Click Yes.