TR_CAREERLEVELCODE_DELETE_BBNCCODETABLEIDMAP

create trigger TR_CAREERLEVELCODE_DELETE_BBNCCODETABLEIDMAP on dbo.CAREERLEVELCODE after delete not for replication as begin delete from dbo.BBNCCODETABLEIDMAP where CODETABLECATALOGID = '65a81a1f-4c0d-4db3-a5db-2557e2aea3b1' and TABLEENTRYID in (select ID from deleted) end