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