25112
asked on
Checking if Constraint is on
how can we check if the constraint has a check or nocheck right now? I could not see it from
SELECT * FROM sys.objects WHERE type_desc LIKE '%CONSTRAINT'
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
anujnb, that was it. can you spin that on sql 2005 sys.objects?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thank you.
Open in new window