is there more the two primary key in a single table?

Answer Posted / navaneethakrishnan

no we cannot,

but we can do composite key in sql2005,

go in enterprise manager...

in the design view first set the primary key to one field
and then press ctrl key and set primary key to another field..

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does truncate do?

521


How to move database physical files in ms sql server?

515


what is a transaction and what are acid properties? : Sql server database administration

516


Name the different type of indexes in sql?

519


How to connect a database with sql express.?

555






How to get the definition of a user defined function back?

554


What is merge replication?

698


What is a system database and what is a user database?

569


What are wait types?

576


you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration

541


Can we use where and having clause together?

498


How to transfer an existing table from one schema to another schema in ms sql server?

500


What is normalization and its types?

524


How each E-R model constructs can be mapped to the relational model?

543


What does <> symbol mean?

539