Public Enum ForeignKeyAction Inherits System.Enum
Dim instance As ForeignKeyAction
public enum ForeignKeyAction : System.Enum
__value public enum ForeignKeyAction : public System.Enum
public enum class ForeignKeyAction : public System.Enum
Public Enum ForeignKeyAction Inherits System.Enum
Dim instance As ForeignKeyAction
public enum ForeignKeyAction : System.Enum
__value public enum ForeignKeyAction : public System.Enum
public enum class ForeignKeyAction : public System.Enum
| Member | Description |
|---|---|
| Cascade | Corresponding rows are updated or deleted in the referencing table when that row is updated or deleted in the parent table. CASCADE cannot be specified if a timestamp column is part of either the foreign key or the referenced key. |
| NoAction | The Database Engine raises an error and the delete or update action on the row in the parent table is rolled back. |
| SetDefault | All the values that make up the foreign key are set to their default values if the corresponding row in the parent table is updated or deleted. For this constraint to execute, all foreign key columns must have default definitions. If a column is nullable, and there is no explicit default value set, NULL becomes the implicit default value of the column. |
| SetNull | All the values that make up the foreign key are set to NULL when the corresponding row in the parent table is updated or deleted. For this constraint to execute, the foreign key columns must be nullable. |
System.Object
System.ValueType
System.Enum
KellermanSoftware.NetDataAccessLayer.ForeignKeyAction
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2