Hi,

> Is it possible to alter the check clauses in a domain
>
> I have the following domain
>
> CREATE DOMAIN dm_ModeType AS CHAR(1)
> CHECK (VALUE IN ('C','O', 'S', 'V'));
>
> and the domain must now be changed to
>
> CREATE DOMAIN dm_ModeType AS CHAR(1)
> CHECK (VALUE IN ('C','L','O', 'S', 'V')); ==> added 'L'

Just for fun, I ran the first CREATE DOMAIN statement in
Database Workbench and modified the domain in the
Domain Editor to show you what a decent GUI tool can do
for you... ;-)

The DDL generated for this change:
ALTER DOMAIN DM_MODETYPE DROP CONSTRAINT;
ALTER DOMAIN DM_MODETYPE ADD CONSTRAINT CHECK (VALUE IN ('C','O', 'S', 'V',
'L'));

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com