Unique Keys

In this window, you can define unique key constraints for your table, ensuring that the combination of values in the selected columns is always unique for every row. You can add or delete unique key constraints using the + Add and X Delete Selected buttons.

You can configure the following for a unique key:

• Name: The name of the unique key. You can edit the name by double-clicking the cell.

• Enabled: If this option is selected, then the unique key constraint will be enabled.

• Rely: If this option is selected, then the constraint can be relied upon.

• Deferrable: If this option is selected, then the constraint check can be deferred until the transaction is committed.

• Initially Immediate: If this option is selected, then the constraint is enforced immediately.

• Validate: If this option is selected, then data in the table must comply with the unique key constraint.

• Index: This drop-down list allows you to select an existing index to associate with the unique key constraint.

• Tablespace: This drop-down list allows you to select a tablespace for storing the index.

• Available Columns and Selected Columns: These lists allow you to select one or more columns to be included in the unique key. Select columns from the Available Columns list and use the arrow buttons to move them to the Selected Columns list.

Once your unique key configuration is complete, click Apply to save your changes.