TR_ASSETVALUATIONMETHODCODE_DELETE_BBNCCODETABLEIDMAP

create trigger TR_ASSETVALUATIONMETHODCODE_DELETE_BBNCCODETABLEIDMAP on dbo.ASSETVALUATIONMETHODCODE after delete not for replication as begin delete from dbo.BBNCCODETABLEIDMAP where CODETABLECATALOGID = 'abce6371-519a-425d-8f2c-85be89f552bc' and TABLEENTRYID in (select ID from deleted) end