TR_RECOGNITIONDECLINEDLEVELREASONCODE_DELETE_BBNCCODETABLEIDMAP

create trigger TR_RECOGNITIONDECLINEDLEVELREASONCODE_DELETE_BBNCCODETABLEIDMAP on dbo.RECOGNITIONDECLINEDLEVELREASONCODE after delete not for replication as begin delete from dbo.BBNCCODETABLEIDMAP where CODETABLECATALOGID = 'ef9290a7-4c7b-4d47-b0ff-a462b0ead34e' and TABLEENTRYID in (select ID from deleted) end