Archives of the TeradataForum

Message Posted: Wed, 28 Dec 2011 @ 16:48:31 GMT

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

<-- Anonymously Posted: Wednesday, December 28, 2011 11:35 -->

Hi Sravan,

If the table is defined as 'SET' then it won't allow duplicates even if it has a NUPI. But if it has a UPI, then instead of doing a duplicate check for each column, it will restrict to the UPI check alone.

HTH.

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