Equivalent of Cascade delete, cascade update and cascade restrict in Teradata

Data Modeling
sg
New Member

Equivalent of Cascade delete, cascade update and cascade restrict in Teradata

Hi,

 

I just want to know if there is something similar or equivalent to CASCADE DELETE, CASCADE UPDATE or CASCADE RESTRICT in Teradata?

 

 

Thanks,

SG

1 REPLY
Highlighted
Teradata Employee

Re: Equivalent of Cascade delete, cascade update and cascade restrict in Teradata

Teradata does not support CASCADE (or explicit RESTRICT) for foreign key constraints. For database-enforced (Referential Integrity or Batch Referential Integrity) constraints, the action is always implicitly RESTRICT.