In the primary key have a multiple field or not?
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 does it mean to normalize data?
What are rest-style architecture's?
What are the triggers in sql?
What is transaction server consistency?
What is a ddl statement?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
How can we migrate from SQL server to SQL Azure?
What is the optimization being performed in oracle and SQL Server?
Explain table valued parameters in sql server? Why tvp used?
How to delete an existing database user?
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration
What do you understand by user-defined function in the sql server?
What is the difference between varchar and varchar(max) datatypes?
Does a sql server 2005 select statement require a from?
How to rebuild the master database?