Subject ALTER CHECK CONSTRAINT - possible?
Author plinehan
Hi all,


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 - www.openehr.org 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?

TIA.


Paul...