Hi Helton,

> Given de table bellow, how can I alter the column constraint to another

values after the table has been created ? Or I will have to drop the column
and create it again ?

>
> CREATE TABLE Test
> (
> FIELD1 CHAR NOT NULL CHECK (FIELD1 IN ('A','B'))
> );
>

This constraint will end up as a table-constraint. Use any GUI tool and you
should be able to change/drop it - have a look at Firebird Workbench or
InterBase Workbench - www.upscene.com


With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase
http://www.upscene.com

Firebird Workbench - the developer tool for Firebird
http://www.upscene.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."