Hi, I was wondering wether it's possible to define a complex uniq

moritzw over 11 years ago

Hi,

I was wondering wether it's possible to define a complex unique constraint within a cdt definition. How would I model for example a contraint like this:

CONSTRAINT uc_PersonID UNIQUE (P_Id,LastName)?

Another question I have related to this is how would I define a complex primary key?

Thanks,

Moritz...

Discussion posts and replies are publicly visible

Parents

0 moritzw over 11 years ago

Hi Patty,

I was talking about a primary key as used in the following table:

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)
)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 moritzw over 11 years ago

Hi Patty,

I was talking about a primary key as used in the following table:

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)
)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data