Primary key:it can not be null Unique:it can have only one null value in

what is difference between primary key and Unique

Question Posted / naresh

Answer Posted / naresh

Primary key:it can not be null

Unique:it can have only one null value in a table.

Is This Answer Correct ?

13 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is sql server 2000 work load governor?

1035

What are the different types of normalization?

1132

What encryption security is available in sql azure?

101

What the difference between UNION and UNIONALL?

1018

Can foreign key be duplicate?

1035

How do I port a number to sql server?

1017

What is the purpose of self join?

950

What are the main differences between #temp tables and @table variables and which one is preferred?

1061

what is the difference between openrowset and openquery?

1067

What is the default Port No on which SQL Server listens?

1108

last function used in MS Access to convert sql what function will use in sql

2055

Tell me what do you understand by a view? What does the with check option clause for a view do?

994

Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

1014

How to name query output columns in ms sql server?

946

How to define and use table alias names in ms sql server?

1101