DELETE FROM dpt_trans;

  
    UPDATE ar SET department_id = 0;

  
    UPDATE ap SET department_id = 0;

  
    UPDATE gl SET department_id = 0;

  
    DELETE FROM department;

  
That is it.