primary key : primary key dose not except null value unique key : it acce

What is differance unique key and primary key.

Question Posted / rahul khanke

Answer Posted / rahul khanke

primary key : primary key dose not except null value
unique key : it accept null values.. if it set to not null
then it as good as primary key.

Is This Answer Correct ?

5 Yes

0 No

Please Help Members By Posting Answers For Below Questions

what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?

2488

Is left join and outer join same?

1069

what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba

1033

describe mysql connection using mysql binary. : Sql dba

1066

Is trigger a stored procedure?

933

Why do we use view in sql?

961

which command using query analyzer will give you the version of sql server and operating system? : Sql dba

1058

how do you control the max size of a heap table? : Sql dba

978

How many types of tables are there?

952

How to pipe multiline string to isql?

1005

how do you tune the slow running queries in oracle db , explain the methodology

2785

Does mysql_real_escape_string prevent sql injection?

946

How is a PL/SQL code compiled?

1230

Which is faster union or join?

972

What is the use of partition by in sql?

994