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.