Loading

relation between two tables

zozo mehr

hi
there is a relation between two my tables in sql database . i dont want CasCade state. i wanna delete a record from tabal1 but i'll encounter a error because of relation and NoAction State.
in fact i wanna have permisssion of deleting data from tabal1 without influense on table2.
is it possible?

1 Reply

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

Sivaraman Dhamodaran13y ago
If your back end is Oracle, then you can do it with deferrable constraint. Search for that in google. Be careful when you do it as you are doing a logical data corruption when doing so..
0