Validating a Unique, Primary or Foreign Key Constraint

Check the validity of unique, primary, or foreign key constraint on system store (IQ catalog store) table.

Prerequisites
Database Version Table Constraint Privileges
SAP Sybase IQ 15.3 and 15.4 Requires one of:
  • DBA authority.
  • VALIDATE authority.
SAP Sybase IQ 16.0 Requires VALIDATE ANY OBJECT system privilege.
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 a system store table in the right pane, click the drop-down arrow that appears to the right, and select Properties.
  4. Select Constraints.
  5. Select a unique, primary, or foreign key constraint from the list.
    Note: Not all constraints can be rebuilt. If a selected constraint cannot be rebuilt, the Validate button is unavailable.
  6. Click Validate.
    The Validate Constraint view appears indicating the validation status.
  7. Click OK.
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
Generating Constraint DDL Commands
Viewing or Modifying Constraint Properties
Authenticating a Login Account for a Managed Resource
Related reference
Table Constraints Privilege Summary