Deleting a Primary, Foreign, or Unique Key Constraint

Delete a primary, foreign, or unique key constraint from a table.

Prerequisites

Database Version	Table Constraint Privileges
SAP Sybase IQ 15.3 and 15.4	Requires one of: DBA authority. ALTER and REFERENCE permission on the underlying table. You own the underlying table.
SAP Sybase IQ 16.0	Requires one of: ALTER ANY OBJECT system privilege. ALTER ANY TABLE system privilege. ALTER and REFERENCE permission on the underlying table. You own the underlying table.

Task

In the Perspective Resources view, select the resource and select Resource > Administration Console.
In the Administration Console, expand IQ Servers > Schema Objects > Tables.
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.
Select Constraints.
Select one or more primary, foreign, or unique key constraints from the list.

Note: Different system privileges are required to delete different constraint types. If you do not have sufficient privilege to delete a selected constraint, the Delete button is unavailable.
Click Delete.
The selected constraints are removed from the list, but they are not yet deleted. Click Apply and OK to complete the deletion process.