Hello Michael,

>> ALTER DOMAIN domainname DROP CONSTRAINT;
>> ALTER DOMAIN domainname ADD CONSTRAINT CHECK (...);
> Thank you, that worked perfectly well :-)
>
>> Or use a GUI tool like Database Workbench that does this for you. ;)
> Good idea generally, but i need to automate this via a script :-)

Of course, but you could see the result without having to check the
documentation. ;)

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!