USE AdventureWorks
GO
ALTER TABLE HumanResources.JobCandidateHistory
CHECK CONSTRAINT CK_JobCandidateHistory_Rating
GO
/*
ALTER TABLE HumanResources.JobCandidateHistory
CHECK CONSTRAINT DF_JobCandidateHistory_Rating
GO
*/
INSERT INTO HumanResources.JobCandidateHistory (Rating) VALUES (20); --не должно сработать