Archives of the TeradataForum

Message Posted: Tue, 28 Sep 2004 @ 08:59:01 GMT

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

Hi Narayan,

In Teradata Primary keys are choosen as Unique Primary Index.In your create table statement you didnt specify index ,so it made the primary key column as Unique Primary Index.

If you have primary index defined on some other column ,then the primary key column will be implemented as Unique Secondary Index.

Keys are implemeneted in Teradata has Indexes.Thats why you get the primary key column as Unique Primary Index .

Thanks & Regards,

Lakshman

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