Find constraint disabled in SQL Server I'm doing an audit of constraints in SQL Server.

How to find all constraints that are not enabled?

This, after using the next declaration:

alter table mytable nocheck constraint all
Use the system views for this:

select * from sys.check_constraints
where is_disabled = 1;