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