Re: Adding Constraints

From: Adrian Billington <billiauk_at_yahoo.co.uk>
Date: 12 Mar 2002 00:12:34 -0800
Message-ID: <dee17a9f.0203120012.6d36293_at_posting.google.com>

Bob

Primary Key

---

ALTER TABLE my_table ADD PRIMARY KEY(id); --to let Oracle name your constraint OR
ALTER TABLE my_table ADD pk_my_table PRIMARY KEY(id); --to name it yourself

Foreign Key

---

ALTER TABLE my_table
ADD fk_my_table
FOREIGN KEY(my_fk_column)
REFERENCES my_parent_table(parent_pk_column);

Regards

Adrian Received on Tue Mar 12 2002 - 09:12:34 CET