Re: Adding constraint

"corrado brambilla" <corrado.brambilla_at_iol.it> a écrit dans le message news: 3A76ADF4.25BE6207_at_iol.it...
> Hi folks
>
> In my DB I use a table like this
>
> Table: TEST
>
> Name Null? Type
> -------------------------- -------- ----
> TEST NOT NULL VARCHAR2(1)
> .... ........ ...........
>
>
> The column TEST have a the following column constraint:
>
> TEST CHECK IN ('P','N').
>
> I need to alter the constraint adding value 'L'.
>
> Can you help me ?
>
> Thank in advance.
>
> Corrado
>

You have to drop and recreate the constraint: alter table test drop constraint ...;
alter table test add (constraint test_chk check (test in ('P','N','L')));

--
Have a nice day
Michel