TR_MKTPLANITEMCATEGORYCODE_DELETE_BBNCCODETABLEIDMAP

create trigger TR_MKTPLANITEMCATEGORYCODE_DELETE_BBNCCODETABLEIDMAP on dbo.MKTPLANITEMCATEGORYCODE after delete not for replication as begin delete from dbo.BBNCCODETABLEIDMAP where CODETABLECATALOGID = '182af1fa-6b7b-4733-9599-9b65d2c6575f' and TABLEENTRYID in (select ID from deleted) end