Unique key allow null value and it is a non cluster index Primary key does

what is difference between primary key and Unique

Question Posted / navneet sharma

Answer Posted / navneet sharma

Unique key allow null value and it is a non cluster index
Primary key does not allow null value and it is custer index

Is This Answer Correct ?

4 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are sub reports and how to create them?

124

What are the different types of replication you can set up in sql server?

983

Sql server reporting services vs. Crystal reports.

118

What is log ldf?

930

How many instances per computer are there in sql server 2000?

1009

What is forward - only cursors / read only cursor?

1019

What is the fastest way to permanently delete a 1 million row table named customers?

1152

What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?

1115

What protocol does sql server use?

882

Should you normalize audio?

879

How to enforce security in sql server? : sql server security

1039

What is BCNF? How is it better than 2NF & 3NF?

963

Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

956

How to concatenate two character strings together?

1056

What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.

1200