Interested to Buy Any Domain ? << Click Here >> for more details...
In the primary key have a multiple field or not?
- 8 Answers
- 9220 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 types of Joins are possible with Sql Server?
What is the meaning of sql server?
What are the disadvantages of primary key and foreign key in SQL?
How do you migrate data from mssql server to azure?
Explain what is meant by replication of database?
What is the name of the Database which IBM mainframe uses?
How to execute stored procedure in select statement sql server?
What is the contrast between sql and mysql?
Do you know what is similarity and difference between truncate and delete in sql?
We need to perform what steps in the following order to work with a cursor?
How to check status of stored procedure in sql server?
What is field in algebra?
How many types of the database links?
List all the types of user-defined functions?
What are .mdf files?
