Re: Foreign composite keys

hi Gabe
Gabe Goldhirsh wrote:
>
> 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)
> );

        FOREIGN KEY(user_id, password) REFERENCES etc...

Regards

         Konstantin V. Sartakov
                Kuzbassprombank
                       Kemerovo
                         Russia
           mailto:skv_at_kpbank.ru