CHECKCONSTRAINTS
This command can be run as follows:
- DBCC CHECKCONSTRAINTS (TableName) - checks an individual table
- DBCC CHECKCONSTRAINTS (ConstraintName) - checks an individual constraint
- DBCC CHECKCONSTRAINTS WITH ALL_CONSTRAINTS - checks all constraints in the database
- DBCC CHECKCONSTRAINTS WITH ALL_ERRORMSGS - returns all rows that violate constraints
- DBCC CHECKCONSTRAINTS WITH NO_INFOMSGS - suppress messages when query runs