Check Constraints

[Han You]

Is there any way to modify an existing CHECK constraint on a table without doing a drop and add? I am interested in this for both 9i and 10g. Thanks to anyone that has an answer in advance.

[Campbell Ritchie]

Don't know. I Googled and found this, whihc suggests you can't alter a constraint.

[Agador Paloi]

can alter table to add constraint, for example:

ALTER TABLE table_name
ADD (CONSTRAINT constr_name CHECK ( yes_no_col_name IN ('N', 'Y')))

[Hemavathy Ramamoorthy Gopal]

Hi,

In oracle modifying exsiting constraints without dropping it is not possible. Always this two steps need to be followed Step 1 : Drop the constraints if exist. Step 2 : Add the constraints.

[Han You]

Ok, thanks for the feedback. My suspicion of not being able to modify constraints was confirmed. Good to know.