Re: help: how do you rename a primary key

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 11 Apr 2002 06:40:41 +0200
Message-ID: <3s4abuoieodk408cjoo7tqsb6sev7k4rtd@4ax.com>

On Thu, 11 Apr 2002 03:17:53 GMT, "Joe Sath" <dbadba62_at_hotmail.com> wrote:

>Hi, Folks
>
>I need to rename a primary key with a unick index. The table is big, if I
>drop the primary key and then rebuild it with "using index", it will take a
>while.
>
>Is there any way we can just rename it like we rename a index?
>
>Thanks for your help.
>

This question would best be answered by the Sql reference manual. Obviously: NO, you have to drop and recreate it.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Apr 10 2002 - 23:40:41 CDT