Enum ForeignKeyRuleType

Namespace

YndigoBlue.Velocity.Enums

Assembly

YndigoBlue.Velocity.dll

Specifies the referential action to take when a referenced row is updated or deleted.

public enum ForeignKeyRuleType

Fields

Cascade = 0

Cascade deletes or updates from the parent to the referenced table.

NoAction = 1

Do not allow deletes or updates on the parent table that have matching rows in the referenced table.

Restrict = 2

Do not allow deletes or updates on the parent table that have matching rows in the referenced table.

SetDefault = 3

When updates or deletes happen in the parent table, set the foreign key columns in the matching rows to their default value.

SetNull = 4

When updates or deletes happen in the parent table, set the foreign key columns in the matching rows to NULL.

Remarks

Foreign key rules define what happens to child table rows when the parent table row they reference is modified or removed. These rules maintain referential integrity while providing flexibility in how cascading changes are handled.