In the primary key have a multiple field or not?
- 8 Answers
- 7959 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is an execution plan?
What are drillthrough reports?
What is clr ddl trigger?
How to find index size for each index on table?
How is SQL Azure different than SQL server?
What is difference between getdate and sysdatetime in sql server 2008?
What is logshipping and its purpose?
What is sql server transaction log file?
How to generate create table script on an existing table in ms sql server?
What are the restrictions applicable while creating views? : SQL Server Architecture
what is denormalization and when would you go for it? : Sql server database administration
How exceptions can be handled in sql server programming?
What is a subquery in a select query statement in ms sql server?
What do you mean by an execution plan?
What is the purpose of optimization?
