what is the different between unique+not null & primary key,
Answer Posted / giri
unique:it does not allow duplicate values but it allow null values.
not null:It does not allow null values but allow duplicate values.
primary:It does not allow both duplicate and null values.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is auto increment in sql?
What are the types of sql commands?
Is left join same as join?
what are the 'mysql' command line arguments? : Sql dba
What is synchronized subquery?
which operator is used in query for pattern matching? : Sql dba
Is left join inner or outer by default?
what are the advantages a stored procedure? : Sql dba
What do we need to check in database testing?
What are the syntax and use of the coalesce function?
What is bind reference and how can it be created?
Can primary key be changed?
What are sql data types?
Is sql considered coding?
Which are the different types of indexes in sql?