Re: Delete cascade?

J=F8rgen Jamt wrote: > = > I'm developing a Client/Server application on an Oracle platform. My > application needs to work the same way on different db-platforms. > = > I was wondering if THIS platform supports a "ON DELETE CASCADE" - funct= ion, > or do I have do delete all the child-records manually? > = > Please respond by e-mail to: > jorgenj@bgnett.no > = > Thank you, > J=F8rgen. Jorgen, when you specify the foreign key constraint in the child record, you can specify: ON DELETE CASCADE I have never used this and have preached against its excessive use because one stray delete can have such far-reaching effects when you have a few layers of cascading delete. But, like an assasin (what an analogy! ;0) it has its uses. -- = -- Jake (Engaged in the persuit of undomesticated aquatic avians) = +-----------------------------------------------------------+ | Impeccable Logic: A thought process which successfully | | resists chicken bites | +-----------------------------------------------------------+