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

Where cross join is used?

706


Delete duplicate rows without using rowid.

1279


You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?

105


When I delete any data from a table, does the sql server reduce the size of that table?

773


What is self contained scalar sub query?

717


What is role playing dimension with two examples? : sql server analysis services, ssas

792


explain what is raid and what are different types of raid configurations? : Sql server database administration

745


whats the maximum size of view state??

1918


How the authentication mode can be changed?

864


Define full outer join?

714


What do you mean by stored techniques? How would we use it?

794


What command do we use to rename a db, a table and a column?

678


What is a partitioned view?

777


What is read committed?

777


What is a data collection table?

744