TR_TAXSTATUSCODE_DELETE_BBNCCODETABLEIDMAP

create trigger TR_TAXSTATUSCODE_DELETE_BBNCCODETABLEIDMAP on dbo.TAXSTATUSCODE after delete not for replication as begin delete from dbo.BBNCCODETABLEIDMAP where CODETABLECATALOGID = '31cac19c-95ce-4c54-a1cb-3ee74ec0a27d' and TABLEENTRYID in (select ID from deleted) end