Delete Employees and Departments

CREATE PROC usp_DeleteEmployeesFromDepartment
AS
ALTER TABLE Departments
ALTER Column ManagerID INT NULL

ALTER TABLE Departments
DROP CONSTRAINT FK_Departments_Employees

ALTER TABLE Employees
DROP CONSTRAINT FK_Employees_Departments, FK_Employees_Employees

DELETE FROM EmployeesProjects
WHERE EmployeeID IN
(SELECT EmployeeID FROM Employees AS e
JOIN Departments AS d ON e.DepartmentID = d.DepartmentID
WHERE d.Name IN ('Production', 'Production Control'))

DELETE FROM Employees
WHERE DepartmentID IN
(SELECT d.DepartmentID FROM Departments AS d
WHERE d.Name IN ('Production', 'Production Control'))

DELETE FROM Departments
WHERE Name IN ('Production', 'Production Control')