Unanswered: How to delete a row from Parent table without delete a row from Child table
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.