Unique Key creates Non-Cluster index in default, But in Primary Key create

When we can declare a column as Unique and Not Null both at
the same time. What is the use pf Primary Key then?

Question Posted / thanga prabu.n

Answer Posted / thanga prabu.n

Unique Key creates Non-Cluster index in default,
But in Primary Key creates Cluster index in default

Is This Answer Correct ?

16 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is use of trigger?

933

Is sql injection illegal?

1025

what are the different functions in sorting an array? : Sql dba

1024

What is the best sql course?

985

How delete a row in sql?

996

Does truncate require commit?

976

What is orm in sql?

1051

How many joins in sql?

1012

What is normalisation in sql?

1059

what is a scheduled jobs or what is a scheduled tasks? : Sql dba

962

How do I copy a table in sql?

989

What does select * from mean in sql?

3240

What is difference between sql function and stored procedure?

1008

how to fetch common records from two tables? : Sql dba

1174

what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba

1048