TR_COUNTRY_DELETE_BBNCCODETABLEIDMAP

CREATE trigger TR_COUNTRY_DELETE_BBNCCODETABLEIDMAP on dbo.COUNTRY after delete not for replication
as begin
  delete from dbo.BBNCCODETABLEIDMAP 
    where CODETABLECATALOGID = '6DCD65EA-4D60-4C43-BA04-63DFC0087212'
    and TABLEENTRYID in (select ID from deleted)
end