SQL Server - The INSERT statement conflicted with the CHECK constraint

In SQL Server, you may get the following error: The INSERT statement conflicted with the CHECK constraint when adding a new column to a table that was not listed in the Constraint.