Referential Integrity for temporal tables

General
Teradata Employee

Referential Integrity for temporal tables

Hi Everyone,

I am trying to write a SOFT RI between a bi temporal parent table and non Tempral child table but it is thoring me an error "Invalid referential integrity definition"

ALTER TABLE EMAIL

ADD CONSTRAINT ALE_SDRI_2  

 NONSEQUENCED VALIDTIME  

 FOREIGN KEY (LOCATION_ID) 

 REFERENCES   WITH NO CHECK OPTION

 LOCATION    (LOCATION_ID) ;

I don't know where I am going wrong...

Tags (2)
1 REPLY
Enthusiast

Re: Referential Integrity for temporal tables

Though, i was getting another error.

But, this might be of some help : 

http://forums.teradata.com/forum/database/creating-a-soft-ri