RE: How do I modify a check constraint?

From: Adams, Matthew (GEA, 088130) <MATT.ADAMS_at_APPL.GE.COM>
Date: Thu, 7 Sep 2000 14:29:15 -0400
Message-Id: <10612.116436@fatcity.com>

I've personally never figure out a way without dropping and re-creating the constraint.

---

R. Matt Adams - GE Appliances - matt.adams_at_appl.ge.com

It will make sense when you stop thinking logically and start thinking Oracle-ly - Jim Droppa

> -----Original Message-----
> From: Cherie_Machler_at_gelco.com [mailto:Cherie_Machler_at_gelco.com]
> Sent: Thursday, September 07, 2000 2:41 PM
> To: Multiple recipients of list ORACLE-L
> Subject: How do I modify a check constraint?
>
>
> Can I modify an existing check constraint chk_status on
> column STATUS of table
> REP_BANK? I've been trying all the syntax variations that I
> can dream up to no
> avail. Is there a way to modify the constraint or do I need
> to drop it and
> recreate it?
>
> What is the correct syntax to do so?
>
> Thanks in advance for helping with this irritating task.
>
> Cherie
>
>
> --
> Author:
> INET: Cherie_Machler_at_gelco.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Thu Sep 07 2000 - 13:29:15 CDT