T-SQL Adventure Works DB Error messages

[yeshk]

Hi Lads

 

Have been getting an error on the AdventureWorks DB, I would be eternally grateful for some help, any help at all. thank you!

 

 

/*

Q13

Schema(s) involved: [HumanResources]

 

Question: Remove all shifts from [HumanResources].Shift except for Day,Evening,Night

if they exist.

 

*/---------------------------------------------------------------------------------------------------

 

 

IF EXISTS(SELECT Name FROM HumanResources.Shift WHERE Name in('Day','Evening','Night'))

DELETE from HumanResources.Shift WHERE Name in('Day','Evening','Night')

----

I get the below error message:

 

The DELETE statement conflicted with the REFERENCE constraint "FK_EmployeeDepartmentHistory_Shift_ShiftID". The conflict occurred in database "AdventureWorks", table "HumanResources.EmployeeDepartmentHistory", column 'ShiftID'.

The statement has been terminated.