A check constraint is a rule applied to a database column to ensure that all values in the column satisfy specific conditions, thereby maintaining data integrity. It is evaluated whenever data is inserted or updated in the column, and if the condition is not met, the operation is aborted, preventing invalid data entry.