Re: check constraints

On 29-Jun-98 16:37:23 adpctre wrote:

>I have a check (column) constraint. I need to either drop the
>constraint entirely or add some values to it. From the documentation,
>it looks like column constraints can't be modified and I can't figure
>out the syntax on how to drop or disable it.

>Can anyone tell me how to do this?

Hello,

as far as i know, column constraints behave just as table constraints after they have been defined.
That means you can use the alter table approach. You might have to query USER_CONSTRAINTS to find out the constraint name. If you did not specify a name, the constraint is named SYS000123 or the like. I don't know if it is possible to add some values to a check constraint but dropping it and recreating it (then as a table constraint) definitively works.

Hope that helps,
Lothar

--

Lothar Armbrüster       | lothar.armbruester_at_rheingau.netsurf.de
Schulstr. 12            | lothar.armbruester_at_t-online.de
D-65375 Oestrich-Winkel |