All Forums General
bhushandhiran 1 post Joined 06/13
12 Jun 2013
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...

Bhushan Dhiran
taruntrehan 43 posts Joined 10/12
26 Jun 2013

Though, i was getting another error.
But, this might be of some help : 
http://forums.teradata.com/forum/database/creating-a-soft-ri

Regards,
Tarun Trehan
http://allzhere.in

You must sign in to leave a comment.