In SQL Server, Data Definition Language (DDL) constraints are also used to enforce rules on the structure of a database table, ensuring data integrity and consistency by enforcing certain conditions ...

-- The value in a column or a set of columns matches a value in a primary key or a unique key -- in another table, establishing a link between the data in the two tables.