Review your business rules and determine if your RI needs to change or not. The next question would be, if they are truly child records, why do they need to exist without a parent record? What purpose do they serve? What information does the parent record contain and what information is stored in the child records? Changing RI may force you to validate your code throughout your app where insertions, updates, and deletions are processed.
>i need to delete master related records without deleting the child ones. is it possible?
>thanks in advance.
.·*´¨)
.·`TCH
(..·*
010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"