Explanation/Reference:
Explanation:
Box 1: CHECKCONSTRAINTS
DBCC CHECKCONSTRAINTS checks the integrity of a specified constraint or all constraints on a specified table in the current database.
Box 2: ALL_CONSTRAINTS
ALL_CONSTRAINTS checks all enabled and disabled constraints on the table if the table name is specified or if all tables are checked;otherwise, checks only the enabled constraint.
Note: Syntax: DBCC CHECKCONSTRAINTS
[
(
table_name | table_id | constraint_name | constraint_id
)
]
[WITH
[{ ALL_CONSTRAINTS | ALL_ERRORMSGS } ]
[, ] [NO_INFOMSGS ]
]
References: https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc- checkconstraints-transact-sql