Re: Foreign composite keys

From: Gerard H. Pille <ghp_at_santens.be>
Date: 1997/06/18
Message-ID: <01bc7bd5$0b2a3fe0$7b1340c0@pcghp.santens.be>#1/1

foreign key (user_id, password) references ...

Gabe Goldhirsh <ggoldh1_at_triton.towson.edu> schreef in artikel <33A68D04.425B_at_triton.towson.edu>...
> In ORACLE 7, what is the syntax for constructing a foreign composite
> key, so far I have: [and am still getting an error]
> DROP TABLE account;
> CREATE TABLE account
> (
> server VARCHAR2(15),
> memory VARCHAR2(15),
> classification VARCHAR2(15),
> user_id VARCHAR2(15),
> password VARCHAR2(15),
> FOREIGN KEY (user_id)
> AND FOREIGN KEY (password)
> );
>
Received on Wed Jun 18 1997 - 00:00:00 CDT