Combined Key Help!!!

From: Yiannis Alevizos <ag907942_at_stmail.staffs.ac.uk>
Date: 1998/02/28
Message-ID: <6d9of5$db9$1_at_plug.news.pipex.net>#1/1


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 Sat Feb 28 1998 - 00:00:00 CET

Original text of this message