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 / pardeeep

NO,A table have only one primary key.But we can use it on more then one column.
Exp..
create table emp(empno int,ename nvarchar(20),deptno int,constraint Pk_constraint primary key( empno,deptno))
This query for SQL server

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are all the different normalization?

1024


Is postgresql a server?

1032


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

1029


Is truncate ddl or dml?

976


What if we write return in procedure?

1401


Is it possible to create startup or shutdown trigger for on-schema?

1012


Explain the order of sql statement execution?

1028


What are functions in sql?

936


how to delete an existing column in a table? : Sql dba

988


What is a schema sql?

1126


How many types of triggers exist in pl/sql?

1051


what is a tablespace? : Sql dba

1038


What is the difference between the implicit and explicit cursors?

1034


how to get @@error and @@rowcount at the same time? : Sql dba

1010


How can we avoid duplicating records in a query?

958