TR_APPEALREPORT1CODE_DELETE_BBNCCODETABLEIDMAP

create trigger TR_APPEALREPORT1CODE_DELETE_BBNCCODETABLEIDMAP on dbo.APPEALREPORT1CODE after delete not for replication as begin delete from dbo.BBNCCODETABLEIDMAP where CODETABLECATALOGID = '56ac8442-ffc9-44b7-b85b-6fd9c6b25821' and TABLEENTRYID in (select ID from deleted) end