0
Answer

SQL Server Using Both Foreign Key and Check Constraint

What is the purpose of SQL Server MS creating a check constraint after creating a foreign key constraint?  Doesn't the foreign key constraint already check itself?