Dear Experts,

I have created a parent table named as facility and its primary key is acting as a foreign key in LHS table including UPDATE CASCADE option.

Now, I want to delete a row from parent table without deleting a row from child table where parent table's primary key is acting as a foreign key, but whenever I try such a thing it prompt an error regarding foreign key.

I know that I have to delete a row from child table and then from parent table, but is there any way that rather to delete a row from child it just place a null value in the foreign key column through a SQL Command.

I am waiting for your suggestion and if it is possible for you then kindly send me a syntax for it.

Thank you in advance and looking forward to your reply.

Regards,
M.A.Bamboat