How to modify a FOREIGN KEY constraint (Enterprise Manager)

To modify a FOREIGN KEY constraint

1. Expand a server group; then expand a server.
2. Expand Databases, expand the database in which the table belongs, and then click Tables.
3. In the details pane, right-click the table, and then click Design Table.
4. Right-click any column; then click Properties.
5. Click the Relationships tab.
6. Click the relationship in the Selected relationship list.
7. Optionally:
   • In Foreign key table, click a different table column from the list to change the table involved in the relationship,

     The foreign key column must match the data type and size of the primary key column.

   • Select Check existing data on creation to ensure that existing data in the foreign key columns matches data in the PRIMARY KEY or UNIQUE constraint columns.
   • Clear Enable relationship for INSERT and UPDATE to disable a FOREIGN KEY constraint for INSERT and UPDATE statements.

     After you add or modify data, you should select this option if you want to ensure the constraint applies to subsequent data modifications.

   • Clear Enable relationship for replication to disable a FOREIGN KEY constraint for replication.

See Also