1 -- @tag: drop_dpt_trans
2 -- @description: Löscht nicht mehr benötigte Tabelle dpt_trans
3 -- @depends: release_3_0_0
6 -- Drop table dpt_trans:
9 -- Drop all Trigger which manage dpt_trans:
10 DROP TRIGGER check_department ON ar;
11 DROP TRIGGER check_department ON ap;
12 DROP TRIGGER check_department ON gl;
13 DROP TRIGGER check_department ON oe;
14 DROP TRIGGER del_department ON ar;
15 DROP TRIGGER del_department ON ap;
16 DROP TRIGGER del_department ON gl;
17 DROP TRIGGER del_department ON oe;
19 -- Drop all functions where dpt_trans is used:
20 DROP FUNCTION check_department();
21 DROP FUNCTION del_department();