TR_RESERVATIONNOTETYPECODE_DELETE_BBNCCODETABLEIDMAP

create trigger TR_RESERVATIONNOTETYPECODE_DELETE_BBNCCODETABLEIDMAP on dbo.RESERVATIONNOTETYPECODE after delete not for replication as begin delete from dbo.BBNCCODETABLEIDMAP where CODETABLECATALOGID = '7e289b15-877b-4400-a9f5-56c540730bb1' and TABLEENTRYID in (select ID from deleted) end