TR_SUFFIXCODE_DELETE_BBNCCODETABLEIDMAP

create trigger TR_SUFFIXCODE_DELETE_BBNCCODETABLEIDMAP on dbo.SUFFIXCODE after delete not for replication as begin delete from dbo.BBNCCODETABLEIDMAP where CODETABLECATALOGID = 'dc8ef6f2-3a35-445d-afcb-b913604cc322' and TABLEENTRYID in (select ID from deleted) end