Deleting a Sequence Generator

Delete one or more sequence generators.

Prerequisites
Database Version Sequence Generator Privileges
SAP Sybase IQ 15.3 and 15.4 You must have one of:
  • DBA authority
  • You own the sequence generator
SAP Sybase IQ 16.0 You must have one of:
  • DROP ANY SEQUENCE system privilege
  • DROP ANY OBJECT system privilege
  • You own the sequence generator
Task
  1. In the Perspective Resources view, select the resource, and select Resource > Administration Console.
  2. In the left pane, expand IQ Servers > Schema Objects, and then select Sequence Generators.
  3. Select one or more sequence generators from the right pane and either:
    • Click the arrow to the right of the name and select Delete, or
    • From the Administration Console menu bar, select Resource > Delete.
    Tip: Use Shift-click or Control-click to select multiple sequence generators.
  4. Verify that the list of sequence generators to be deleted is correct and click Yes.
Related tasks
Creating a Sequence Generator
Restarting a Sequence at Start Value
Generating Sequence Generator DDL Command
Viewing or Modifying Sequence Generator Properties
Granting Sequence Generator USAGE Permission
Revoking Sequence Generator USAGE Permission
Authenticating a Login Account for a Managed Resource
Related reference
Sequence Generator Privilege Summary