In the primary key have a multiple field or not?

Categories >> Software >> Databases >> SQL Server
Suggest New Category

Question Posted / jivi.preethi

8 Answers
7085 Views
TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

In the primary key have a multiple field or not?..

Answer / jivi.preethi

yes,it having multiple field

Is This Answer Correct ?

16 Yes

1 No

In the primary key have a multiple field or not?..

Answer / prashanth kumar

Yes , it have multiple fields.Run below query and creating
primary key on p_Id and LastName.

CREATE TABLE Persons
(
P_Id int NOT NULL,
LastName varchar(255) NOT NULL,
FirstName varchar(255),
Address varchar(255),
City varchar(255),
CONSTRAINT pk_PersonID PRIMARY KEY (P_Id,LastName)
)

Is This Answer Correct ?

9 Yes

0 No

In the primary key have a multiple field or not?..

Answer / vinay

yes it multiple field

Is This Answer Correct ?

4 Yes

0 No

In the primary key have a multiple field or not?..

Answer / anubhav tyagi

Yes,it Have Multiple Field, But Not same

Is This Answer Correct ?

1 Yes

0 No

In the primary key have a multiple field or not?..

Answer / rajkumar

s primary key have the multiple filed use os composite
primary key.

Is This Answer Correct ?

1 Yes

0 No

In the primary key have a multiple field or not?..

Answer / ziyaur rahman

no,in one table there is only one primary key field

Is This Answer Correct ?

2 Yes

2 No

In the primary key have a multiple field or not?..

Answer / prasadhari_m@yahoo.com

A TABLE ALLOWS ONLY ONE PRIMARY KEY.

Is This Answer Correct ?

0 Yes

1 No

In the primary key have a multiple field or not?..

Answer / vernold

NO, we only have 1 FIELD FOR PRIMARY KEY

Is This Answer Correct ?

3 Yes

5 No

Post New Answer