tww
.tww_sys
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
disable_symbology_triggers()
Parameters
Name
Type
Mode
IN
Definition
BEGIN ALTER TABLE tww_od.reach_point DISABLE TRIGGER on_reach_point_update; ALTER TABLE tww_od.reach DISABLE TRIGGER on_reach_2_change; ALTER TABLE tww_od.reach DISABLE TRIGGER on_reach_1_delete; ALTER TABLE tww_od.wastewater_structure DISABLE TRIGGER on_wastewater_structure_update; ALTER TABLE tww_od.wastewater_networkelement DISABLE TRIGGER ws_label_update_by_wastewater_networkelement; ALTER TABLE tww_od.structure_part DISABLE TRIGGER on_structure_part_change; ALTER TABLE tww_od.cover DISABLE TRIGGER on_cover_change; ALTER TABLE tww_od.wastewater_node DISABLE TRIGGER on_wasterwaternode_change; ALTER TABLE tww_od.reach DISABLE TRIGGER ws_symbology_update_by_reach; ALTER TABLE tww_od.channel DISABLE TRIGGER ws_symbology_update_by_channel; ALTER TABLE tww_od.reach_point DISABLE TRIGGER ws_symbology_update_by_reach_point; ALTER TABLE tww_od.reach DISABLE TRIGGER calculate_reach_length; RETURN; END;