Cascade Delete T-Sql

CascadeDelete.sql

USE master;
DROP DATABASE Experiment;

CREATE DATABASE Experiment;
USE Experiment;

CREATE TABLE dbo.Departments 
(
	departmentid INT PRIMARY KEY IDENTITY,
	name NVARCHAR(100) NOT NULL
);

CREATE TABLE dbo.Employees
(
	employeeid INT PRIMARY KEY IDENTITY,
	name NVARCHAR(200) NOT NULL,
	departmentid INT 

	CONSTRAINT Fk_Departments FOREIGN KEY (departmentid)
		REFERENCES dbo.Departments (departmentid)
		ON DELETE SET NULL
);

INSERT INTO dbo.Departments
	VALUES ('Human Resources');

INSERT INTO dbo.Employees
	VALUES ('Toby Flenderson', 1);


DELETE
FROM dbo.Departments
WHERE departmentid = 1

SELECT *
FROM dbo.Employees