Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Help: Cross-Referenced Foreign Keys
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
![]() |
![]() |