Archives of the TeradataForum

Message Posted: Wed, 01 Feb 2006 @ 22:13:49 GMT

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

There is one key difference between a UPI on a set table and a UPI on a multiset table is that the insert of a duplicate row into a set table with a UPI will not generate an error, while the insert of a duplicate row into a multiset table with a UPI will generate a Unique Prime Key Error.

Also, please remember that one of the reasons for inclusion of multiset table creation in Teradata was to be ANSI compliant. Therefore, standards at your shop might dictate the creation of a multiset table with a UPI (even though some might not believe that it makes any sense).

Jeff Pankow, Technical Consultant
Retail DW Business Solutions
Teradata, a division of NCR Corporation

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