TR_ETHNICITYCODE_DELETE_BBNCCODETABLEIDMAP

create trigger TR_ETHNICITYCODE_DELETE_BBNCCODETABLEIDMAP on dbo.ETHNICITYCODE after delete not for replication as begin delete from dbo.BBNCCODETABLEIDMAP where CODETABLECATALOGID = '087e04cc-b6db-46f7-89e4-428a47b7999b' and TABLEENTRYID in (select ID from deleted) end