The CHECK constraint limits the value range that can be placed in a column. It ensures only specific values are accepted either on a single column or based on conditions across multiple columns.