By default Primary Key Create Cluster index while unique ker create non c

What's the difference between a primary key and a unique key?

Question Posted / awdhesh

Answer Posted / awdhesh

By default Primary Key Create Cluster index while unique
ker create non cluster index

Is This Answer Correct ?

17 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is lookup override?

1079

What is order of B+tree?

1152

How to create a user to access a database in ms sql server using "create user" statements?

990

Do you know the different ddl commands in sql?

1096

What is table join?

1166

What is attribute hierarchy? : sql server analysis services, ssas

1060

Does partitioning improve performance?

1016

How to enter unicode character string literals in ms sql server?

1112

How you can minimize the deadlock situation?

1081

What is the importance of a recovery model?

1090

what is a correlated sub-query? : Sql server database administration

985

How to create a view on an existing table in ms sql server?

1182

Explain encryption of entire databases without the need for application changes in sql server 2008?

1087

How to use group functions in the select clause in ms sql server?

1110

Can you explain full-text query in sql server?

1055