RE: how to change a foreign key back to a primary key.Thank You.

[Meomeo Nguyen]

Richard and Igor,

Thank you both for your quick answers.  I do appreciate it very much.  The statements work well.

Again, thanks for your help.

Trang

  Richard Huntley <[EMAIL PROTECTED]> wrote:

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

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

---

Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup