Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Adding a Foreign Key Reference to a table

Re: Adding a Foreign Key Reference to a table

From: janet <janet_at_telesph.com>
Date: 1997/03/03
Message-ID: <331AFA2D.11A7@telesph.com>#1/1

ALTER TABLE table_name
ADD CONSTRAINT constraint_name FOREIGN KEY (col1, col2)
REFERENCES table_2
(cola,colb)
/

Rob Cole wrote:
>
> Is it possible to add a foreign key reference to a table using the ALTER TABLE
> command. I have tried to find examples of this in the documentation with no
> success.
Received on Mon Mar 03 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US