TR_EDUCATIONALINSTITUTION_DELETE_BBNCCODETABLEIDMAP (Trigger)

                
                    CREATE trigger TR_EDUCATIONALINSTITUTION_DELETE_BBNCCODETABLEIDMAP on dbo.EDUCATIONALINSTITUTION after delete not for replication
                    as
                    begin
                        delete from dbo.BBNCCODETABLEIDMAP
                        where CODETABLECATALOGID = '0E885882-A716-49B8-8F2F-A6BAE5D220D8'
                            and TABLEENTRYID in (select ID from deleted)
                    end