Deleting data from both Parent and underlying foreign key related tables at same time

Database
Enthusiast

Deleting data from both Parent and underlying foreign key related tables at same time

Hi,

Is there any way to delete data from parent as well as the underlying tables which are assosiated with foreign key relation??

1 REPLY
Junior Supporter

Re: Deleting data from both Parent and underlying foreign key related tables at same time

There is not 'ON DELETE CASCADE' in Teradata (if that's what you are looking for.

You should handle the whole delete process within a transaction (implicit or explicit).

HTH.

Cheers.

Carlos.