Hi,

> I created a check constraint in a domain without a name leaving firebird

to

> create its own name
>
> I now need to change the check details and need to drop the existing
> constraint
>
> - How do I find the name so that it can be dropped I have searched the
> system tables but need a little help here
>
> I know that it can be changed using 3rd party tools but I need to do it in
> an update script.

Just do:

ALTER DOMAIN mydomain DROP CONSTRAINT;
ALTER DOMAIN mydomain ADD CONSTRAINT CHECK (<new constraint>)

Martijn Tonies
Database Workbench - development tool for Firebird and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com