TR_FUNDINGPLANDEPARTMENTCODE_DELETE_BBNCCODETABLEIDMAP

create trigger TR_FUNDINGPLANDEPARTMENTCODE_DELETE_BBNCCODETABLEIDMAP on dbo.FUNDINGPLANDEPARTMENTCODE after delete not for replication as begin delete from dbo.BBNCCODETABLEIDMAP where CODETABLECATALOGID = '1f88fea6-65fe-4d2c-b39a-6dacddf0d44d' and TABLEENTRYID in (select ID from deleted) end