Documentation Home
MySQL NDB Cluster API Developer Guide
Download this Manual ForeignKey::FkAction

FkAction is an enumeration which represents a reference action for a foreign key when an update or delete operation is performed on the parent table.

Enumeration values.  Possible values are shown, along with the corresponding reference action, in the following table:

Table 2.22 ForeignKey::FkAction data type values and descriptions

Name Description
NoAction NO ACTION: Deferred check.
Restrict RESTRICT: Reject operation on parent table.
Cascade CASCADE: Perform operation on row from parent table; perform same operation on matching rows in child table.
SetNull SET NULL: Perform operation on row from parent table; set any matching foreign key columns in child table to NULL.
SetDefault SET DEFAULT: Currently not supported in NDB Cluster.

See also FOREIGN KEY Constraints, in the MySQL Manual.