Re: Modifying check constraints

On Wed, 14 Nov 2001, Paulo Jan wrote:

> Hi all:
>
>         Let's suppose I create a table with a CHECK constraint, like:
>
>         CREATE TABLE blabla (id int, tipo varchar(8),
>         CHECK tipo IN ('tipo1', 'tipo2', 'tipo3'))
>
>         Can I change the CHECK constraint afterwards? For example, can I
> add another value that "tipo" can have, or I'd have to recreate the
> table?

Right now, I think you'd need to recreate, but 7.2 should let you drop
and re-add the check constraint.