Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Adding a Foreign Key Reference to a table
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