TR_FUNDINGREQNOTETYPECODE_DELETE_BBNCCODETABLEIDMAP

create trigger TR_FUNDINGREQNOTETYPECODE_DELETE_BBNCCODETABLEIDMAP on dbo.FUNDINGREQNOTETYPECODE after delete not for replication as begin delete from dbo.BBNCCODETABLEIDMAP where CODETABLECATALOGID = 'b5a766e3-36ac-486f-b4a7-8758e8c95e82' and TABLEENTRYID in (select ID from deleted) end