Re: changing constraints

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 20 Nov 2001 21:26:34 +0100
Message-ID: <tvlo5cc4tr0q0c@corp.supernews.com>

"Jayne Heger" <jayne_at_spamwithchips@sphynx.clara.co.uk> wrote in message news:1006283581.16111.1_at_eurus...
> Hello,
>
> I have created a few tables in SQL*Plus Oracle 8i, in one of my tables I
> have specified a constraint so that only the few words stored in the
> constraint can be input.
> I seem to have done this wrong however, so wish to go back and change it.
> Can this be done - easily?
>
> Thanks
>
> Jayne

alter table <table_name> drop constraint <constraint_name>; alter table <table_name> add constraint <constraint_name>...

2 commands

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address

Received on Tue Nov 20 2001 - 14:26:34 CST