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 are the basic sql commands?
how to drop an existing table in mysql? : Sql dba
Is it possible to create startup or shutdown trigger for on-schema?
Is sql scripting language?
what is “go” in t-sql? : Transact sql
What does stand for in sql?
What do you mean by table in sql?
what is 'mysqlcheck'? : Sql dba
What is difference sql and mysql?
what is sql profiler? : Sql dba
What is having clause in sql?
What is meant by user defined function?
Is the primary key an index?
What is the least restrictive isolation level? : Transact sql
Explain what is a field in a database and record in a database?