Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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 different types of stored procedures?

0 Answers  


What is index in an assignment?

0 Answers  


what are database files and filegroups? : Sql server database administration

0 Answers  


How to copy the tables, schema and views from one sql server to another?

0 Answers  


How to Run a Query on a Remote SQL Server?

2 Answers  






How do I find the query plan in sql server?

0 Answers  


what are defaults? Is there a column to which a default can't be bound? : Sql server database administration

0 Answers  


What is attribute hierarchy? : sql server analysis services, ssas

0 Answers  


Do you know what are the ways available in sql server to execute sql statements?

0 Answers  


How do I find the sql server database version?

0 Answers  


I have a website that allows customers to browse and place orders for certain products. I have 2 tables; Customers and Orders. The Customers table holds the customer records and the Orders table holds the orders placed by the customer. Both tables are tied based on the field Cust_ID. Example of the data is shown below: Cust_ID Cust_Name Cust_ID Product Amount Order_Date 1001 John Tan 1001 P-5211 $120.00 2/13/2006 1002 Michael Wong 1001 K-1428 $88.90 1/11/2006 1003 Mary Cheong 1003 C-0923 $82.50 1/27/2006 1004 Ahmad Suffian 1003 K-1428 $88.90 2/2/2006 Write a single SQL statement that extracts all purchase records with the following criteria: 1. Customer names starting with “M” only. 2. Orders placed within the current month only. 3. Amount does not exceed $100.00 The list must be sorted by order date with the latest order showing on top.

3 Answers   Techno Solutions,


How to update values in a table with update statements in ms sql server?

0 Answers  






Categories