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

What is the use of stored procedures?

1051

What are analytic functions in sql?

1025

What is record type in pl sql?

991

How can I tell if sql is running?

1064

How subquery works in sql?

1067

Define tables and fields in a database

1130

Explain aggregate functions are available there in sql?

1007

What is numeric function sql?

1058

Is natural join same as inner join?

940

What is a common use of group by in sql?

1051

what is top in tsql? : Transact sql

1117

What is meant by user defined function?

1050

What is keys and its types?

1075

what is data control language? : Sql dba

1024

What is constant in pl sql?

1022