Rebuild a unique, primary, or foreign key constraint on a 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.
- 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 INDEX system privilege.
- REFERENCE permission on the underlying table.
- You own the underlying table.
|
-
The
SAP Sybase IQ resource is authenticated and running.
-
In a multiplex configuration, the coordinator node is
running.
Task- In the Perspective Resources view, select the resource and
select .
- In the Administration Console, expand .
- 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.
- Select Constraints.
- Select a unique, primary, or foreign key constraint from the list.
Note: Not all constraints can be rebuilt. If a selected constraint cannot be
rebuild, the Rebuild button is unavailable.
- Click Rebuild
The Rebuild Constraint view appears indicating the rebuilding
status.
- Click OK.