TR_DONORCHALLENGESPONSORCODE_DELETE_BBNCCODETABLEIDMAP

create trigger TR_DONORCHALLENGESPONSORCODE_DELETE_BBNCCODETABLEIDMAP on dbo.DONORCHALLENGESPONSORCODE after delete not for replication as begin delete from dbo.BBNCCODETABLEIDMAP where CODETABLECATALOGID = '4c60a6e3-4b33-4fcd-9335-df6fb120ea9c' and TABLEENTRYID in (select ID from deleted) end