TR_CHURCHAFFILIATIONCODE_DELETE_BBNCCODETABLEIDMAP

create trigger TR_CHURCHAFFILIATIONCODE_DELETE_BBNCCODETABLEIDMAP on dbo.CHURCHAFFILIATIONCODE after delete not for replication as begin delete from dbo.BBNCCODETABLEIDMAP where CODETABLECATALOGID = '515ab684-7043-4fd8-9cc5-f714e52215f1' and TABLEENTRYID in (select ID from deleted) end