Online Documentation for SQL Administrator for SQL Server

Properties


Use the Properties tab of the Foreign Key Editor to create/edit a foreign key constraint and specify its properties.

 

Name

Enter a name for the new foreign key, or modify the name of the foreign key being edited.

 

Foreign key Editor - Properties

 

 

Table

In this field the Table name of the foreign key being edited is displayed.

 

!CheckBox Enabled

Enables/disables the foreign key immediately after it is created.

 

!CheckBox Check existing data

This option specifies whether the data in the table is or is not validated against a newly added or re-enabled foreign key.

 

Update action / Delete action

  • No action

Produce an error indicating that the deletion or update would create a foreign key constraint violation. If the constraint is deferred, this error will be produced at constraint check time if there still exist any referencing rows. This is the default action.

  • Cascade

Delete any rows referencing the deleted row, or update the value of the referencing column to the new value of the referenced column, respectively.

  • Set null

Set the referencing column(s) to null.

  • Set default

Set the referencing column(s) to their default values.

 

!CheckBox Not for replication

This option allows you to specify that the foreign key should not be enabled when a replication agent modifies the table that is involved in the foreign key.