On Thu, Jul 17, 2008 at 10:52 AM, Douglas McNaught <doug@xxxxxxxxxxxx> wrote: > On Thu, Jul 17, 2008 at 12:11 PM, Ismael .... <ismaelpsp@xxxxxxxxxxx> wrote: >> >> hi >> I have one of those master-detail relationships here and I need to be able >> to delete the master but leave the details untouched > > Then remove the referential integrity constraint, since it's obviously > incompatible with your business requirements. Generally I'd agree, but it might be useful to set the child record referencing id field to NULL in this circumstance.
