TR_ARRIVALAREACODE_DELETE_BBNCCODETABLEIDMAP

create trigger TR_ARRIVALAREACODE_DELETE_BBNCCODETABLEIDMAP on dbo.ARRIVALAREACODE after delete not for replication as begin delete from dbo.BBNCCODETABLEIDMAP where CODETABLECATALOGID = '11a58ab3-45a3-4162-a1f4-c0e77f0054f9' and TABLEENTRYID in (select ID from deleted) end