primary key will not allow null values.but in case of unique,more than on

IN A TABLE HAVE ONE COLUMN PRIMARY KEY..IT WILL NOT ALLOWS
NULL VALUES AND DUPLICATE VALUES..INSTEAD OF PRIMARY KEY
WHY CANT WE USE UNIQUE AND NOT NULL.THESE TWO ALSO DOESNT
ACCEPT NULL VALUES IN NOT NULL AND UNIQUE DOESNT ACCEPT
DUPLICATE VALUES?
SO WHAT IS THE DIFEERENCE BETWEEN(UNIQUE,NOT NULL) AND
PRIMARY KEY??????

Question Posted / john

8 Answers
10721 Views
rsystems, I also Faced
E-Mail Answers

Answer Posted / john

primary key will not allow null values.but in case of
unique,more than one null value s accepted.

Is This Answer Correct ?

2 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what is 'mysqld'? : Sql dba

1014

What is a recursive stored procedure?

1248

What is scope and visibility in PL/SQL?

1284

What is the use of count (*) in sql?

1113

What is the trigger in sql?

1001

Which is faster subquery or join?

1267

Can you do multiple joins in sql?

1116

What is difference between primary and secondary key?

1072

What is pl sql block structure?

1086

Is primary key is clustered index?

1039

Can we use view in stored procedure?

953

What is sql used for?

1161

What is data control language (dcl)?

1202

What are dml commands?

1069

Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

1147