Interview Questions   Tutorials   Discussions   Programs   

Teradata - I have not defined PRIMARY INDEX or PRIMARY KEY on table what will happen now:?




643
views
asked vishnoiprem August 17, 2014 05:33 AM  

I have not defined PRIMARY INDEX or PRIMARY KEY on table what will happen now:?


           

1 Answers



 
answered By vishnoiprem   0  
 
1) I have not defined PRIMARY INDEX or PRIMARY KEY on table what will happen now: In this case, Teradata will check if any column is defined as UNIQUE, then it will make that column as UNIQUE PRIMARY INDEX else first column will be created as PRIMARY INDEX.

2) I have not defined PRIMARY INDEX however a column is defined as PRIMARY KEY: In this case, Teradata will make the PRIMARY KEY column as UNIQUE PRIMARY INDEX of the table.

3) I have defined both PRIMARY KEY and PRIMARY INDEX on different column: In this case, Teradata will make PRIMARY KEY column as UNIQUE SECONDARY INDEX i.e. UNIQUE INDEX on the table.
flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert