ForeignKeyAction Enumeration

Specifies the action that is taken when the primary key that is referenced by a foreign key is updated.

Namespace:  Microsoft.SqlServer.Management.SqlParser.Metadata
Assembly:  Microsoft.SqlServer.Management.SqlParser (in Microsoft.SqlServer.Management.SqlParser.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.
SetDefault The foreign key is set to the default value.
SetNull The foreign key is set to null.