|
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?
Navigation:
[Reply to this message]
|