Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: Order of columns
 
From:   Christopher Craig

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>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 23 Jun 2019