Subject Re: [firebird-support] ALTER CHECK CONSTRAINT - possible?
Author Thomas Steinmaurer
> I'm about to start a project for College (final
> year - I've gone back - decided that I'm a
> frustrated acadmic!).
> Anyway, I used FB successfully for a project last
> year - embedded server on Linux - worked like a
> charm, and I would like to use it again for my
> (very (very...)) important final year project.
> The project is to do with storing clinical data
> in an XML-like format - for those
> interested - ehr stands for electronic health record.
> I would like to know if it is possible to dynamically
> modify CHECK constraints - or do I have to drop the
> original one and then create a new one?
> Any input appreciated. I did a google and don't appear
> to have come up with anything - I can enable and disable
> them, drop and create them, but can I ALTER them?

No. Btw, how do you enable/disable them?

Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
My blog: