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.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.SqlEnum (in Microsoft.SqlServer.SqlEnum.dll)
Syntax
'Declaration
Public Enumeration ForeignKeyAction
'Usage
Dim instance As ForeignKeyAction
public enum ForeignKeyAction
public enum class ForeignKeyAction
type ForeignKeyAction
public enum ForeignKeyAction
Members
| Member name | Description | |
|---|---|---|
| NoAction | No action is taken. | |
| Cascade | The modification is also made to the foreign key. | |
| SetNull | The foreign key is set to null. | |
| SetDefault | The foreign key is set to the default value. |
Remarks
The ForeignKeyAction enumeration class is served by the UpdateAction property and the DeleteAction property.