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 difference between primary key & unique index ?

Answer Posted / mani

Primary key can be defined only one for a table whereas
number of unique indexes can be defined for a table.

primary key can not have null values but unique can have
null values and to remind one null value can never be equal
to another null value.

Is This Answer Correct ?    23 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you mean by between and in? Is between inclusive of specified range values?

1088


How do you select a row using indexes in db2?

1133


How to find primary key of a table in db2?

1061


What is the picture clause of null indicator variable?

1136


Are views updateable?

1150


What kind of database is db2?

1030


How connect db2 database to datastage?

1232


What is a Foreign Key?

1095


What is meant by explain?

1125


What is bind package and plan in db2?

1053


What are the uses of db2 optimizer?

1293


On which levels locks can be applied?

1123


What is dbrm? What it contains?

1161


In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

1044


Is db2 a programming language?

1044