Archives of the TeradataForum

Message Posted: Tue, 03 Feb 2004 @ 20:37:12 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

We would like to use Hard and Soft RI to get better performance out of Teradata. However, Arcmain copy does not support RI unless we do a restore and validate structure. I am interested in writing a script to retrieve the Hard and Soft RI when we backup the database. When I need to copy to another database, the RI definition will be applied.

Question is after looking at :

All_RI_Children
All_RI_Parents,
RI_Child_Tables
RI_Distinct_Children
RI_Distinct_Parents
RI_Parent_Tables

I could not find anything that differentiate the Hard and Soft RI. I am sure Teradata keeps it some where.

Thanks

Kim Lee

	<Prev	Next>		<<First	<Prev	Next>	Last>>