Re: Rename a constraint

From: Syarzhuk Kazachehnka <bamboo7431_at_hotmail.com>
Date: Wed, 06 Jan 1999 22:45:22 GMT
Message-ID: <770p21$c94$1@nnrp1.dejanews.com>

gennick_at_worldnet.att.net wrote:
> >Is there a way to rename a constraint in Oracle using SQL ? I need
> >to rename the system generated constraint to a different name.
>
> No. You need to drop and recreate the constraint.
How do I retrieve the name of a system generated constraint? I have a table created with:
CREATE TABLE Tablename(
...,
FieldName VarChar(50) UNIQUE,
...
);

I need to get rid of the UNIQUE constraint but can't find the way to get the constraint name out of the system.

Sincerely,

Syarzhuk

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Jan 06 1999 - 16:45:22 CST