Restarting a Sequence at Start Value

Restart the sequence generator at the start value defined.

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:
  • ALTER ANY SEQUENCE system privilege.
  • ALTER 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, select IQ Servers > Schema Objects > Sequence Generators.
  3. Select a sequence generator from the right pane and either:
    • Click the arrow to the right of the name and select Restart At Start Value, or
    • From the Administration Console menu bar, select Resource > Restart At Start Value.
  4. At the confirmation prompt, click Yes.
Related tasks
Creating a Sequence Generator
Deleting a Sequence Generator
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