User Tools

Site Tools


delete_departments_sql_command
no way to compare when less than two revisions

Differences

This shows you the differences between two versions of the page.


delete_departments_sql_command [2016/08/21 19:13] (current) – created sweitmann
Line 1: Line 1:
 +    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.
delete_departments_sql_command.txt · Last modified: 2016/08/21 19:13 by sweitmann