Posted by sarada7 on 03/06/06 18:51

Yes, you are right constraints exist or they don't. My question was is
there any way to verify if any check is existing on a table before
enabling one?

For example, we add a constraint using the following SQL

ALTER TABLE Customers CHECK CONSTRAINT ALL

and disable them using

ALTER TABLE Customers NOCHECK CONSTRAINT ALL

If we run the SQL to disable the constraint. At this point how to
verify if the constraint is not existing?

[Back to original message]