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 difference between "Primary key" and "Unique key"?

Answer Posted / nitin gupta

Uniques: Enforce unique data in the database
it allows row containing null value but only once
It implements non clustered index.

primary key: Enforce unique data in the database
it don't allow any record containing null value
it implements clustered index (data physically
sorted)

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is vector point function?

1050


Can we use join in subquery?

1090


Is it important to partition hard disk?

1022


What packages are available to pl/sql developers?

1045


What is the most important ddl statements in sql are?

991


What is sql*loader and what is it used for?

1147


What are all different types of collation sensitivity?

1028


When is a declare statement required?

1136


what is msql? : Sql dba

988


What is sql keyword?

997


What is ttitle and btitle?

1061


What is informix sql?

975


Is it possible to include an insert statement on the same table to which the trigger is assigned?

1012


What is t sql used for?

1010


How can you know that statistics should be updated?

1077