TR_SCREENPLANSTEPCODE_DELETE_BBNCCODETABLEIDMAP

create trigger TR_SCREENPLANSTEPCODE_DELETE_BBNCCODETABLEIDMAP on dbo.SCREENPLANSTEPCODE after delete not for replication as begin delete from dbo.BBNCCODETABLEIDMAP where CODETABLECATALOGID = '90ed2ef5-afdb-4240-a4bb-e0c361380781' and TABLEENTRYID in (select ID from deleted) end