<< Click to Display Table of Contents >>

Primary Key, Unique, Index

Top Previous Next

This dialog allows you to create a primary key, unique constraint or an index on the table. It is also used to change an existing constraint or index. In this case, Hora drops and re-creates it.

The dialog contains the following information

Create/Add Primary key, Unique constraint or index

Constraint/index name

Tablespace name. You can select an entry from the combo box.

Column list. You can select any subset of the table columns

Disable constraint (yes/no)

Using index clause (yes/no)

Exceptions table name.

After the OK button is pressed, the operation will be performed. The cancel button closes the dialog without any action.