Re: Combined Key Help!!!
From: Mark Cudmore <mcudmore_at_kamloops.env.gov.bc.ca>
Date: 1998/03/03
Message-ID: <1998Mar3.091002.9968_at_vmsmail.gov.bc.ca>#1/1
Date: 1998/03/03
Message-ID: <1998Mar3.091002.9968_at_vmsmail.gov.bc.ca>#1/1
Ok here is your create table that uses a composite primary key
CREATE TABLE TEST(
ID1 NUMBER,
ID2 NUMBER,
PRIMARY KEY(ID1, ID2));
That's all there is to it!
Yiannis Alevizos wrote in message <6d9of5$db9$1_at_plug.news.pipex.net>...
>Hi,
>I am a computing student and I have a project in databases. Could anyone
>help me the combined key command. What's the command in order to have a
>combined primary key in an Oracle table (2 fields). I have already tried
>"create table test (id1 number, id2 number, constraint pktest1 (id1,id2)
>primary key);".
>
>Thank you in advance,
>Ioannis Alevizos
>ag907942_at_stmail.staffs.ac.uk
>
>
Received on Tue Mar 03 1998 - 00:00:00 CET