Primary Key

In this window, you can define the primary key constraint for your table, ensuring that each row is uniquely identifiable.

You can configure the following for a primary key:

• Name: The name of your primary key constraint.

• Enabled: If this option is selected, then the primary 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 primary key constraint.

• Index: This drop-down list allows you to select an existing index to associate with the primary 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 primary key. Select columns from the Available Columns list and use the arrow buttons to move them to the Selected Columns list.

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