ForeignKeyRuleAction Enumeration |
Rule action enum for action type specification with DBForeignKeyConstraint instances.
Namespace: SD.LLBLGen.Pro.Core
Assembly: SD.LLBLGen.Pro.Core (in SD.LLBLGen.Pro.Core.dll) Version: 5.4.0.0 (5.4.0)
SyntaxMembers| Member name | Value | Description | |
|---|---|---|---|
| NoAction | 0 | The Foreign Key field will be left alone. | |
| Cascade | 1 | The Foreign Key field will be deleted together with the row the field is in when the Primary Key field is deleted. The Foreign Key field will be set to the value which is the new value of the Primary Key when the Primary Key is updated. | |
| SetDefault | 2 | The Foreign Key field is set to its default when the Primary Key field is deleted. (if applicable). Not supported in SQLServer 2000. | |
| SetNULL | 3 | The Foreign Key field is set to NULL if the Primary Key field is deleted. Not supported in SQLServer 2000. | |
| Restrict | 4 | The foreign key field is not updated, the removal is restricted. |
See Also