Posted by YZXIA on 12/18/07 23:57

I need to make a primary key, which constitute two different columns
on our MS SQL server. When I wrote the following code I received an
error message:


create table t_dz_borrowing_record
(
CutOffDate datetime not null Primary key,
LoanType varchar(20) not null primary key,
..... More columns
)


Msg 8110, Level 16, State 0, Line 2
Cannot add multiple PRIMARY KEY constraints to table
't_dz_borrowing_record'.

Does anyone know how to make a primary key which is a combination of
two columns?

• Next in forum: Re: Primary Key with two columns
• Prev in forum: Re: Expanding Hierarchies - SQL 2000
• Thread view: Primary Key with two columns

[Reply to this message]