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:

Value Reference Action/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
Sign Up Login You must be logged in to post a comment.