Generating Constraint DDL Commands

Display the data description language SQL code for adding a constraint to a table. The DDL can be a useful reference and training tool.

Prerequisites
Database Version Table Constraint Privileges
SAP Sybase IQ 15.3 and 15.4

None required.
SAP Sybase IQ 16.0

None required.
Task
  1. In the Perspective Resources view, select the resource and select Resource > Administration Console.
  2. In the Administration Console, expand IQ Servers > Schema Objects > Tables.
  3. Select Tables or Global Temporary Tables, select the table in the right pane, click the drop-down arrow that appears to the right, and select Properties.
  4. Select Constraints.
  5. Select a constraint from the list and select Generate DDL.
Parent topic: Table Constraints
Related tasks
Creating a Column Check Constraint
Creating a Foreign Key Constraint
Creating a Table Check Constraint
Creating a Unique Constraint
Deleting a Table or Column Check Constraint
Deleting a Primary, Foreign, or Unique Key Constraint
Rebuilding a Unique, Primary or Foreign Key Constraint
Validating a Unique, Primary or Foreign Key Constraint
Viewing or Modifying Constraint Properties
Authenticating a Login Account for a Managed Resource
Related reference
Table Constraints Privilege Summary