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
'Deklaracja
Public Enumeration ForeignKeyAction
public enum ForeignKeyAction
public enum class ForeignKeyAction
public enum ForeignKeyAction
public enum ForeignKeyAction
Members
| 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. |
Remarks
The ForeignKeyAction enumeration class is served by the UpdateAction property and the DeleteAction property.
Platforms
Development Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server.
Target Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server.