Using Constraints to Enforce Data Integrity

Constraints enforce data integrity on a column (column-level constraints) or on a table (table-level constraints, usually multicolumn constraints). You define constraints by using SQL Enterprise Manager or by using the CREATE TABLE statement. You add and drop constraints by using the ALTER TABLE statement.

SQL Server provides CHECK, DEFAULT, FOREIGN KEY, PRIMARY KEY, and UNIQUE constraints.