composite key syntax 1

[MasterKaos]

Hi i know this is a simple question, but i couldn't find it in the manual.

Whats the syntax for creating a composite primary key?

I need to create an associative entity out of the primary keys tour_id (from tour table) and pickup_id (from pickup table)

----------------------------------------------------------------------------
The first 90% of the code accounts for the first 90% of the development time. The remaining 10% of the code accounts for the other 90% of the development time.

 

[r937]

create table AssociativeEntity
( tour_id integer not null
, pickup_id integer not null
, foreign key (tour_id) references Tours (id)
, foreign key (pickup_id) references Pickups (id)
,primary key (tour_id, pickup_id)
);

rudy

http://r937.com/

SQL Consulting

 

[MasterKaos]

Thank you r937!!!

Man, tek-tips rocks. So much better than reading the manual

----------------------------------------------------------------------------
The first 90% of the code accounts for the first 90% of the development time. The remaining 10% of the code accounts for the other 90% of the development time.