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
You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?
What are commit and rollback in sql?
How to test odbc dsn connection settings?
What is replication and database mirroring?
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
explain databases and sql server databases architecture? : Sql server database administration
What is the difference between char and varchar2 datatype in sql?
Define model database?
Can a table have 2 primary keys?
What is difference between view and materialized view?
Explain important index characteristics?
Explain in brief about Microsoft SQL server?
Which are the important points to note when multilanguage data is stored in a table?
How you provide security to cube? : sql server analysis services, ssas
Can sql servers linked to other servers like oracle?