How do I modify a check constraint?

From: <Cherie_Machler_at_gelco.com>
Date: Thu, 7 Sep 2000 12:35:59 -0500
Message-Id: <10612.116427@fatcity.com>

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 Received on Thu Sep 07 2000 - 12:35:59 CDT

This message: [ Message body ]
Next message: HAWKINS, JAMES W [FND/1000]: "RE: Way to extract SQL from archived redo logs?"
Previous message: dgoulet_at_vicr.com: "Re:Way to extract SQL from archived redo logs?"
Next in thread: Ruth Gramolini: "Re: How do I modify a check constraint?"
Maybe reply: Ruth Gramolini: "Re: How do I modify a check constraint?"
Maybe reply: Adams, Matthew (GEA, 088130): "RE: How do I modify a check constraint?"
Maybe reply: ddorr.cs_at_clearstream.com: "RE: How do I modify a check constraint?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US