TR_STATE_DELETE_BBNCCODETABLEIDMAP

CREATE trigger TR_STATE_DELETE_BBNCCODETABLEIDMAP on dbo.STATE after delete not for replication
as begin
    delete from dbo.BBNCCODETABLEIDMAP 
        where CODETABLECATALOGID = 'FE193125-9AFA-46B8-86BD-E0E1FAB4C32E'
        and TABLEENTRYID in (select ID from deleted)
end