Invalid SQL syntax - only one update rule and/or one delete rule allowed. (Error 3727)

This error occurs when defining referential integrity through SQL DDL. This occurs when NULL or DEFAULT is not used after the SET keyword.