Loading

On delete set null on update set null

Sai Reddy

8y1.4k

Hi,

I have two tables called

University(Had Primary Key)

Student

Here i am trying create fk on Student table with the condition ON UPDATE SET NULL ON DELETE SET NULL

The following is an error.

Msg 1761, Level 16, State 0, Line 1

Cannot create the foreign key "fk_on_Student" with the SET NULL referential action, because one or more referencing columns are not nullable.

Msg 1750, Level 16, State 0, Line 1

Could not create constraint. See previous errors.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nitin Sontakke8y ago
Fortunately, the error is in plain English, clearly stating what the problem is and should be understood and resolved rather quickly.
Rajkiran Swain8y ago
https://www.experts-exchange.com/questions/28933351/SQL-Create-table-fails-with-error-Could-not-create-constraint.html