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


Please Help Members By Posting Answers For Below Questions

What are the basic sql commands?

543


how to drop an existing table in mysql? : Sql dba

550


Is it possible to create startup or shutdown trigger for on-schema?

577


Is sql scripting language?

519


what is “go” in t-sql? : Transact sql

594






What does stand for in sql?

516


What do you mean by table in sql?

521


what is 'mysqlcheck'? : Sql dba

563


What is difference sql and mysql?

527


what is sql profiler? : Sql dba

580


What is having clause in sql?

520


What is meant by user defined function?

575


Is the primary key an index?

588


What is the least restrictive isolation level? : Transact sql

561


Explain what is a field in a database and record in a database?

602