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

Define check constraint.

1025


Where can you declare a cursor in a cobol-db2 program?

994


How do I change the column size in db2?

1082


What is the syntax for FETCH in DB2 ?

1136


Explain package in db2 and its advantages?

1133


What is null indicator in cobol db2?

991


what is the sqlcode -501

12916


How to test SQL -911 error while developing COB-DB2 program

7441


What is cloudant database?

1032


What is iseries database?

989


What is a db2 package?

987


How do you select a row using indexes in db2?

1072


How do I start db2 in windows?

1020


What are the uses of db2 optimizer?

1222


What is a storage group (stogroup)?

1189