Subject | ALTER CHECK CONSTRAINT - possible? |
---|---|
Author | plinehan |
Post date | 2009-09-07T00:08:02Z |
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...
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...