Starting in Informix Version 7, when you create a foreign key you
can specify on delete cascade.
HTH,
Zev Berezin
Informix DBA
B&H Photo ~ http://www.bhphoto.com
Email: zevb@bhphoto.com
On 2 Jun 2003, at 13:21, Ma, Thanh(IndSys, GE Interlog wrote:
> Hi,
>
> When I delete a record I would like to delete all of its associated
> records. Is there a handy tool somewhere that let me identity what the
> associated records are ?
>
> Thanks,
> Thanh
>
>