Re: Rename a table constraint?

From: Kenneth Koenraadt <plovmand_at_hotmail.com>
Date: Fri, 18 May 2001 18:43:53 GMT
Message-ID: <3b056cdb.2302111@news.mobilixnet.dk>

Hi David,

I have checked the 8.1.5 documentation, and there is no option like

"ALTER TABLE rename constraint"

So to me it seems that you must drop and recreate the constraint with a different name :-(

Regards,

Kenneth Koenraadt
Systems Consultant
plovmand@<no-spam>hotmail.com

On Fri, 18 May 2001 10:16:45 +0800, David YEUNG <dyeung_at_ust.hk> wrote:

>How can I rename a primary key constraint in a Oracle table.
>
>Thanks for advice
>
>david
Received on Fri May 18 2001 - 13:43:53 CDT