TR_MEMBERATTACHMENTTYPECODE_DELETE_BBNCCODETABLEIDMAP

create trigger TR_MEMBERATTACHMENTTYPECODE_DELETE_BBNCCODETABLEIDMAP on dbo.MEMBERATTACHMENTTYPECODE after delete not for replication as begin delete from dbo.BBNCCODETABLEIDMAP where CODETABLECATALOGID = 'bd33d17a-b4fc-4b7d-b867-2e9e0e897f53' and TABLEENTRYID in (select ID from deleted) end