Trang,
How
about:
alter
table TABLE_NAME drop constraint CONSTRAINT_NAME;
alter
table TABLE_NAME add constraint pk_TABLE_NAME primary key
(COLUMN)
using
index tablespace indexes;
-----Original Message-----
From: Meomeo Nguyen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 29, 2002 7:06 PM
To: Multiple recipients of list ORACLE-L
Subject: how to change a foreign key back to a primary key
From: Meomeo Nguyen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 29, 2002 7:06 PM
To: Multiple recipients of list ORACLE-L
Subject: how to change a foreign key back to a primary key
Hi,
I need to change a foreign key back to a primary key in a table. How do I do that. Please help.
Thanks in advance.
Trang
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup