Thanks Martijn

I see that it is not necessary to have the constraint name when dropping a
domain constraint

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]On Behalf Of Martijn Tonies
Sent: 25 April 2007 10:36
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Change check constraint in domain


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






[Non-text portions of this message have been removed]