Re: deleting the master but not the detail

On Thu, Jul 17, 2008 at 10:52 AM, Douglas McNaught <doug@mcnaught.org> wrote:
> On Thu, Jul 17, 2008 at 12:11 PM, Ismael .... <ismaelpsp@hotmail.com> 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.