TR_APPEALATTACHMENTTYPECODE_DELETE_BBNCCODETABLEIDMAP

create trigger TR_APPEALATTACHMENTTYPECODE_DELETE_BBNCCODETABLEIDMAP on dbo.APPEALATTACHMENTTYPECODE after delete not for replication as begin delete from dbo.BBNCCODETABLEIDMAP where CODETABLECATALOGID = '9f9d4310-732a-45d8-a27e-f8a748a0ce81' and TABLEENTRYID in (select ID from deleted) end