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?