Archives of the TeradataForum

Message Posted: Sun, 21 Mar 2004 @ 11:17:53 GMT

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

If you do not specify a Primary Index as part of your 'Create Table' DDL, then the machine will create an index by checking the following criteria.

If there is a Primary Key specified, then the table is created with a Unique Primary Index using the Primary Key.

If there is no Primary key, but a column with Unique constraints, then the table is created with a Unique Primary Index using the first column with a unique constraint. (all other columns with Unique constraints are created as Unique Secondary Index).

If neither of these consitions are satisfied, then the table is created with the first column assigned as a non-unique Primary Index.

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