Posted by ZeldorBlat on 03/06/06 19:13

sarada7@gmail.com wrote:
> 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?

Do something that violates the constraint and see if the server
complains.

[Back to original message]