TR_LEDGERACCOUNTMEDIALINKTYPECODE_DELETE_BBNCCODETABLEIDMAP

create trigger TR_LEDGERACCOUNTMEDIALINKTYPECODE_DELETE_BBNCCODETABLEIDMAP on dbo.LEDGERACCOUNTMEDIALINKTYPECODE after delete not for replication as begin delete from dbo.BBNCCODETABLEIDMAP where CODETABLECATALOGID = 'ac15e00e-c100-4c2e-9830-f47214ddacde' and TABLEENTRYID in (select ID from deleted) end