adspace


What is differance unique key and primary key.

Answer Posted / hema

Unique :: it does not allow duplicate values but allows
null values.
Primary:: Primary does not allow duplicate values as wel as
it dosnt allow null values.

unique+not null==Primary key...

Is This Answer Correct ?    6 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

define sql insert statement ? : Sql dba

1098


What is the best sql course?

1050


how to escape special characters in sql statements? : Sql dba

1113


Do we need to rebuild index after truncate?

1137


Does group by remove duplicates?

1112


Can we rollback truncate?

1074


Can we use distinct and group by together?

1133


Is primary key clustered index?

1018


Is inner join faster than left join?

1274


How do I remove duplicates in two columns?

1184


what is dbms? : Sql dba

1061


Is primary key always clustered index?

1094


what are aggregate and scalar functions? : Sql dba

1127


how to use regular expression in pattern match conditions? : Sql dba

1111


how to start mysql server? : Sql dba

1266