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

Explain cursor types?

957


define sql insert statement ? : Sql dba

977


List the various privileges that a user can grant to another user?

990


What is character functions?

1017


How do I run pl sql in sql developer?

1063


What is replication id?

886


How can I tell if sql is running?

998


Can sql developer connect to db2?

989


What is trigger explain with example?

985


how do you know the version of your mysql server? : Sql dba

937


What is sql and its types?

1114


How to write a query to show the details of a student from students table whose

942


In pl/sql, what is bulk binding, and when/how would it help performance?

938


what happens if null values are involved in expressions? : Sql dba

1001


Can we create clustered index without primary key?

901