i am trying to run a query but its not working may be due to constraint
conflicts
i have table A, B and C
B and C have a foreign key linked with A's primary key
so i want to delete an entry from A
for that i hav to delete child records first
can u design a query which wont conflict the constrai
yes i know about on delete cascade
it automatically delete the child when master is deleted
but the database i m working on is not built in this fashion
tables r built on default rules
so constraints r there
i m jus asking to build a procedure or function
that taking from the user and deletes th
