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...

Can a table have two primary keys?

Answer Posted / uhaish

Yes and it can and the number of primary keys in a single
table is not limited and can be 3,4, unlimited .The concept
is imagine 2 primary keys cols in a table as one primary
key col .
which means if you have two cols A and B both are primary
key by defination then..
AB
00
01
02
12
21
21
22

,see individually a primary key col is not anymore unique
but as hole its unique no other row in a table can have the
same combination of these two primary keys i.e '02' cannot
be repeated .

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are enums used for in mysql? : Sql dba

1228


What is synonyms?

1118


Can we use loop in sql?

1010


What is the difference between sql and isql*plus?

1162


What does partition by mean in sql?

1031


How do you update a sql procedure?

1092


name 3 ways to get an accurate count of the number of records in a table? : Sql dba

1116


What is the use of sqlerrd 3?

993


What is execute immediate?

1163


What are all the ddl commands?

1244


What is the difference between function and procedure in pl/sql?

1138


How subquery works in sql?

1129


How do I create a sql script?

1142


What is integrity in sql?

1103


Define join and name different types of joins?

1054