TR_CREDITREASONCODE_DELETE_BBNCCODETABLEIDMAP

create trigger TR_CREDITREASONCODE_DELETE_BBNCCODETABLEIDMAP on dbo.CREDITREASONCODE after delete not for replication as begin delete from dbo.BBNCCODETABLEIDMAP where CODETABLECATALOGID = 'aeb200f3-992f-407c-94cb-bbe2ab97f36c' and TABLEENTRYID in (select ID from deleted) end