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
10712 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

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3617

What is the difference between function, procedure and package in pl/sql?

1343

What are reports usually used for?

1078

Are sql database names case sensitive?

1042

What is nvarchar max in sql?

1071

What are the limitations of sql express?

1114

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

1300

What is the use of primary key?

1047

What is sharding in sql?

1038

Does db2 use sql?

1004

What are sql*plus environment variables?

1145

Is pl sql different from sql?

1039

What is dynamic sql in pl sql?

1083

How much ram can sql express use?

1035

How can we find duplicate records in a table?

988