TR_SMARTFIELDCATEGORYCODE_DELETE_BBNCCODETABLEIDMAP

create trigger TR_SMARTFIELDCATEGORYCODE_DELETE_BBNCCODETABLEIDMAP on dbo.SMARTFIELDCATEGORYCODE after delete not for replication as begin delete from dbo.BBNCCODETABLEIDMAP where CODETABLECATALOGID = '7e1e7e69-4258-4833-b8e5-01dee479b0a1' and TABLEENTRYID in (select ID from deleted) end