TR_DESIGNATIONREPORT1CODE_DELETE_BBNCCODETABLEIDMAP

create trigger TR_DESIGNATIONREPORT1CODE_DELETE_BBNCCODETABLEIDMAP on dbo.DESIGNATIONREPORT1CODE after delete not for replication as begin delete from dbo.BBNCCODETABLEIDMAP where CODETABLECATALOGID = '73520db9-f211-4a62-874f-62a58b06fecc' and TABLEENTRYID in (select ID from deleted) end