TR_PROSPECTPLANMEDIALINKTYPECODE_DELETE_BBNCCODETABLEIDMAP

create trigger TR_PROSPECTPLANMEDIALINKTYPECODE_DELETE_BBNCCODETABLEIDMAP on dbo.PROSPECTPLANMEDIALINKTYPECODE after delete not for replication as begin delete from dbo.BBNCCODETABLEIDMAP where CODETABLECATALOGID = '64cff585-62e7-4141-b18c-34ee4849422f' and TABLEENTRYID in (select ID from deleted) end