Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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 is auto increment in sql?

1061


What are the types of sql commands?

1018


Is left join same as join?

937


what are the 'mysql' command line arguments? : Sql dba

1087


What is synchronized subquery?

1091


which operator is used in query for pattern matching? : Sql dba

947


Is left join inner or outer by default?

973


what are the advantages a stored procedure? : Sql dba

924


What do we need to check in database testing?

964


What are the syntax and use of the coalesce function?

1103


What is bind reference and how can it be created?

965


Can primary key be changed?

869


What are sql data types?

948


Is sql considered coding?

994


Which are the different types of indexes in sql?

991