Re: Update of CHECK constraints

On Thu, 11 Aug 2005 01:00:39 GMT, Mladen Gogala <gogala_at_sbcglobal.net> wrote:

>On Wed, 10 Aug 2005 13:00:29 -0700, Ed Prochak wrote:
>
>> Use the ALTER TABLE command to modify them.
>
>You can rename them, enable or disable them with "ALTER TABLE MODIFY
>CONSTRAINT". I'm not sure if the constraint condition can be changed.

It Can't. Only the constraint state (enable/disable etc) can be modified with "ALTER TABLE". You need to drop and recreate.

• Kenneth Koenraadt