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

Can you get second highest salary from the table?

966

How do I clean up sql server transaction log?

1068

Explain relational data?

927

How to use subqueries in the from clause in ms sql server?

1164

Is it ok to shrink transaction log?

1008

What is DCL?

1053

If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?

1109

Explain differentiate between a having clause and a where clause?

913

How to create a large table with random data for index testing in ms sql server?

1031

How do I view a trc file?

943

What is difference between getdate and sysdatetime in sql server 2008?

1048

When does a workload on SQL Azure get throttled?

131

Is it true, that there is no difference between a rule and a check constraint?

1058

What is store procedure?

1063

How use inner join in sql server?

1134