Primary key creates Clustered Indexes. Clustered indexes physically sort th

IN A TABLE HAVE ONE COLUMN PRIMARY KEY..IT WILL NOT ALLOWS
NULL VALUES AND DUPLICATE VALUES..INSTEAD OF PRIMARY KEY
WHY CANT WE USE UNIQUE AND NOT NULL.THESE TWO ALSO DOESNT
ACCEPT NULL VALUES IN NOT NULL AND UNIQUE DOESNT ACCEPT
DUPLICATE VALUES?
SO WHAT IS THE DIFEERENCE BETWEEN(UNIQUE,NOT NULL) AND
PRIMARY KEY??????

Question Posted / upendra

8 Answers
10445 Views
rsystems, I also Faced
E-Mail Answers

Answer Posted / upendra

Primary key creates Clustered Indexes. Clustered indexes physically sort the data.
Unique can have only Non-clustered indexes, where data are not physically sorted.

Is This Answer Correct ?

14 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Difference between global and parameter variables?

1959

Explain lock escalation? : Transact sql

1187

What is $$ in sql?

982

What are sql procedures?

1016

how is myisam table stored? : Sql dba

1048

What is sql architecture?

1041

does sql support programming? : Sql dba

1033

What is a schema? How is it useful in sql servers?

1106

What is sql and how does it work?

1159

What are the uses of sysdate and user keywords?

1091

what is rdbms? : Sql dba

1005

how to present a past time in hours, minutes and seconds? : Sql dba

1002

What is user in sql?

1013

What is sql catalog?

1007

how to convert numeric values to character strings? : Sql dba

1097