Deleting a Sequence Generator
Delete one or more sequence generators.
Prerequisites
Database Version
Sequence Generator Privileges
SAP Sybase IQ 15.3 and 15.4
Requires one of:
DBA authority.
You own the sequence generator.
SAP Sybase IQ
16.0
Requires one of:
DROP ANY SEQUENCE system privilege.
DROP ANY OBJECT system privilege.
You own the sequence generator.
The SAP Sybase IQ resource is authenticated and running.
Task
In the Perspective Resources view, select the resource and select
Resource
>
Administration Console
.
In the left pane, select
IQ Servers
>
Schema Objects
>
Sequence Generators
.
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.
Verify that the list of sequence generators to be deleted is correct and click
Yes
.
Parent topic:
Sequence Generators
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
Created May 21, 2013. Send feedback on this help topic to Technical Publications:
pubs@sybase.com