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


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

Answers were Sorted based on User's Feedback



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

Answer / sathishrpillai

no, but there can be any number of forgein keys in a single
table.
A primary key of one table is the forgein key for other
table.

Is This Answer Correct ?    4 Yes 2 No

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

Answer / chandra

no, we cant create more than one primary key in the single
bcoz it avoids the codds rule

Is This Answer Correct ?    3 Yes 1 No

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

Answer / elumalai.k

No it is not possible.
A table has only one primary key
If the table has more than one primary key is called
composite key.

Is This Answer Correct ?    3 Yes 1 No

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

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

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

Answer / manoj

cannot add multiple primary key constraint on a single table

Is This Answer Correct ?    2 Yes 0 No

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

Answer / sudheer gowlikar

we cannot have more than one primary key on a table since
primary will create a clustered index and we can have only
1 clustered index on a table since clustered index will
sort data in data pages and the data sorted in one way
rather sorting number of ways.

Is This Answer Correct ?    2 Yes 0 No

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

Answer / ramesh.p

No, One table can have one primary key

Is This Answer Correct ?    2 Yes 1 No

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

Answer / sandeep rana

If table has more than one primary key is called
composite key....

Is This Answer Correct ?    1 Yes 0 No

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

Answer / boominathan

No

Is This Answer Correct ?    12 Yes 12 No

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

Answer / vincent

create table StudMaster(studid int not null,studname varchar
(20) not null,constraint Studmaster primary key clustered
(studid,studname))

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What are the aggregate and scalar functions?

0 Answers  


Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?

0 Answers   HCL,


Explain tablesample?

0 Answers  


In which format does an image save in SQL Server database ?

0 Answers   MCN Solutions,


How to convert a numeric expression from one data type to another?

0 Answers  


What is a subquery in a select query statement in ms sql server?

0 Answers  


Explain relational data?

0 Answers  


how many layers of tcp/ip protocol combined of? : Sql server database administration

0 Answers  


How to maintain a fill factor in existing indexes?

0 Answers  


Difference between Triggers and Stored Procedure

23 Answers   Claimat, HCL, Protech, Silgate,


What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?

3 Answers   HCL,


Can someone suggest me the best institute to learn SQL Server... I want to gain in depth knowledge on SQL Server Development. I have been to naresh, peers, sql school,mind q systems... Any idea about best faculty....

3 Answers  


Categories