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.

The FOREIGN KEY constraint is used to enforce a link between the data in two tables. A foreign key in one table points to a primary key in another table, maintaining referential integrity.