OK. Thank you.
I used drop/create statements and user_constraint table to verify the
constraint value.
<Kenneth Koenraadt> wrote in message
news:42fb46ee.9583109_at_news.inet.tele.dk...
> 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
>
>
Received on Thu Aug 11 2005 - 14:27:59 CDT
