Key Constraints

The Key constraint page displays the key constraint that are defined for this table. You can add a new constraint, view a constraint definition, or remove a constraint. To create a new constraint, click Add. To remove a constraint, click Remove. To view the definition of a constraint, click Definition. You cannot change the constraint definition once the constraint is created. If you want to change a key constraint, you must first delete the constraint and then recreate it.

To view the SQL used to build the constraint, select the constraint and click Show SQL. Once the table is created, Show SQL is unavailable unless a change is made.

The columns available in the key constraint grid are:

Name
The name of the constraint.

Type
The type of constraint.

Key columns
The key columns for the constraint.

The constraint is created when you click OK on the Table Definition dialog.