Generating DDL Commands for Sybase IQ Users or Groups

Display the SQL data description language for creating a user or group. The SQL code can be a useful reference and training tool.

Prerequisites

Authenticate with Sybase IQ using an account that has DBA or User Admin authority.

Task

In the Perspective Resources view, select one or more resources and select Resource > Administration Console.
In the left pane of the Administration Console, select Security > Users or Security > Groups.
Select the user or group from the right pane and either:
- Click the drop-down arrow to the right of the name and select Generate DDL
- From the Administration Console menu bar, select Resource > Generate DDL
The DDL tab opens, showing the SQL code used to create the selected user or group.