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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Help: Cross-Referenced Foreign Keys

Re: Help: Cross-Referenced Foreign Keys

From: Chuck Price <c_price_at_interaccess.com>
Date: Mon, 14 Dec 1998 22:07:54 GMT
Message-ID: <36758be1.11382091@news.interaccess.com>


On Mon, 14 Dec 1998 18:11:02 GMT, tkyte_at_us.oracle.com (Thomas Kyte) wrote:

>Declaritive constraints, including foreign keys, may be altered in after the
>fact. Here is an example:
>
>SQL> alter table t1 add constraint t1_pk primary key(x);
>Table altered.
>

Thanks! I was so close...I didn't give the constraint a name. (I take it that's what the t1_pk is above.

Many thanks, Thomas. Received on Mon Dec 14 1998 - 16:07:54 CST

Original text of this message

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