Delete Employees and Departments 2

CREATE PROC usp_DeleteEmployeesFromDepartment (@departmentId INT)
AS
ALTER TABLE Departments
ALTER COLUMN ManagerID int NULL
ALTER TABLE Employees
DROP FK_Employees_Departments
ALTER TABLE Employees
DROP FK_Employees_Employees
ALTER TABLE Departments
DROP FK_Departments_Employees
ALTER TABLE EmployeesProjects
DROP FK_EmployeesProjects_Employees
DELETE FROM Employees
WHERE Employees.DepartmentID = @departmentId
DELETE FROM Departments
WHERE Departments.DepartmentID = @departmentId

SELECT COUNT(*) FROM Employees
WHERE DepartmentID = 7