Re: Changing Constraint Names ?
From: Elaine Mohrle <magick_at_metronet.com>
Date: 1995/06/08
Message-ID: <3r7vkv$khn_at_feenix.metronet.com>#1/1
Date: 1995/06/08
Message-ID: <3r7vkv$khn_at_feenix.metronet.com>#1/1
comrmb_at_herts.ac.uk (Mike Bearne) wrote:
>Hello,
>I have a series of ORACLE 7 tables which have system-named table and column
>intergrity constraints defined on them (e.g. SYS_C00341 etc).
>I wish to give the constraints more meaningful names, does anybody know how
>I can alter the constraint's name property ?
>Cheers,
>Mike Bearne.
yeah, drop the old one and add it back with a name of your choice. there is no rename command for indexes and constraints. Received on Thu Jun 08 1995 - 00:00:00 CEST