ForeignKeyAction Enumeration
The ForeignKeyAction enumeration is a list of constant values that specify the action that is taken when the primary key reference by a foreign key is updated.
Assembly: Microsoft.SqlServer.SqlEnum (in Microsoft.SqlServer.SqlEnum.dll)
| Member name | Description | |
|---|---|---|
| Cascade | The modification is also made to the foreign key. | |
| NoAction | No action is taken. | |
| SetDefault | The foreign key is set to the default value. | |
| SetNull | The foreign key is set to null. |
The ForeignKeyAction enumeration class is served by the UpdateAction property and the DeleteAction property.
Show: