TR_GENDERCODE_DELETE_BBNCCODETABLEIDMAP

create trigger TR_GENDERCODE_DELETE_BBNCCODETABLEIDMAP on dbo.GENDERCODE after delete not for replication as begin delete from dbo.BBNCCODETABLEIDMAP where CODETABLECATALOGID = 'be6bd11c-d5ca-4d51-92bd-bac9e34afe86' and TABLEENTRYID in (select ID from deleted) end