User Tools

Site Tools


delete_departments_sql_command

Differences

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

Link to this comparison view

delete_departments_sql_command [2016/08/21 19:13] (current)
sweitmann created
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