TR_DISSOLVEREASONCODE_DELETE_BBNCCODETABLEIDMAP

create trigger TR_DISSOLVEREASONCODE_DELETE_BBNCCODETABLEIDMAP on dbo.DISSOLVEREASONCODE after delete not for replication as begin delete from dbo.BBNCCODETABLEIDMAP where CODETABLECATALOGID = '36a4874e-df56-4d31-9ff7-2bf76c8a08b7' and TABLEENTRYID in (select ID from deleted) end