SQL Server Foreign Key Update and Delete Rules

-- Script 1: Create sample tables-- Use required database Use AdventureWorks GO-- Create child table IF EXISTS (SELECT * FROM sys.objects WHERE name = N'EmpEducation' AND [type] = 'U') DROP TABLE EmpEducation CREATE TABLE EmpEducation

www.mssqltips.com