Generating Sequence Generator DDL Command

Generate data description language for one or more sequence generators. The DDL code can be a useful reference and training tool.

Prerequisites
Database Version Sequence Generator Privileges
SAP Sybase IQ 15.3 and 15.4 None.
SAP Sybase IQ 16.0 None.
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 Generate DDL, or
    • From the Administration Console menu bar, select Resource > Generate DDL.
    Tip: Use Shift-click or Control-click to select multiple sequence generators.
  4. The DDL view opens, showing the SQL code used to create the selected sequence generators.
Related tasks
Creating a Sequence Generator
Deleting a Sequence Generator
Restarting a Sequence at Start Value
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