Hi, Primary Key: Not Null+ unique.but it wont allows null values. U

what is difference between "Primary key" and "Unique key"?

Question Posted / satya_k21

4 Answers
9261 Views
PreVator, I also Faced
E-Mail Answers

Answer Posted / satya_k21

Hi,

Primary Key: Not Null+ unique.but it wont allows null
values.

Unique: It allows null values , but it should be unique.

Regards,
Satya.k

Is This Answer Correct ?

3 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is sqlerrm?

919

Can we perform dml on view?

1029

What are the different type of joins in sql?

935

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3557

What found sql?

932

what are the security recommendations while using mysql? : Sql dba

1095

How do you write an index?

949

What is application trigger?

977

What is a join query?

939

What is over () in sql?

931

Compare sql & pl/sql

1104

If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

3988

What is write ahead logging in sql server?

1030

What is secondary key?

920

What are the usages of sql?

1047