Documentation Home
MySQL NDB Cluster API Developer Guide
Download this Manual

2.3.8.2 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.18 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 Using FOREIGN KEY Constraints, in the MySQL Manual.


User Comments
User comments in this section are, as the name implies, provided by MySQL users. The MySQL documentation team is not responsible for, nor do they endorse, any of the information provided here.
Sign Up Login You must be logged in to post a comment.