Mercurial > dive4elements > river

comparison backend/doc/schema/oracle-drop.sql @ 6652:765944ca6df0 double-precision

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
author Tom Gottfried <tom@intevation.de>
date Wed, 24 Jul 2013 18:41:22 +0200
parents 97145ec4e33c
children cfafe5764509
comparison
equal deleted inserted replaced
6651:8782ba5cb222 6652:765944ca6df0
30 ALTER TABLE wst_columns DROP CONSTRAINT cWstColumnsTime_intervals; 30 ALTER TABLE wst_columns DROP CONSTRAINT cWstColumnsTime_intervals;
31 ALTER TABLE wst_columns DROP CONSTRAINT cWstColumnsWsts; 31 ALTER TABLE wst_columns DROP CONSTRAINT cWstColumnsWsts;
32 ALTER TABLE wst_q_ranges DROP CONSTRAINT cWstQRangesRanges; 32 ALTER TABLE wst_q_ranges DROP CONSTRAINT cWstQRangesRanges;
33 ALTER TABLE wsts DROP CONSTRAINT cWstsRivers; 33 ALTER TABLE wsts DROP CONSTRAINT cWstsRivers;
34 ALTER TABLE wsts DROP CONSTRAINT cWstsWstKinds; 34 ALTER TABLE wsts DROP CONSTRAINT cWstsWstKinds;
35 DROP TABLE annotation_types; 35 DROP TABLE annotation_types PURGE;
36 DROP TABLE annotations; 36 DROP TABLE annotations PURGE;
37 DROP TABLE attributes; 37 DROP TABLE attributes PURGE;
38 DROP TABLE cross_section_lines; 38 DROP TABLE cross_section_lines PURGE;
39 DROP TABLE cross_section_points; 39 DROP TABLE cross_section_points PURGE;
40 DROP TABLE cross_sections; 40 DROP TABLE cross_sections PURGE;
41 DROP TABLE discharge_table_values; 41 DROP TABLE discharge_table_values PURGE;
42 DROP TABLE discharge_tables; 42 DROP TABLE discharge_tables PURGE;
43 DROP TABLE edges; 43 DROP TABLE edges PURGE;
44 DROP TABLE gauges; 44 DROP TABLE gauges PURGE;
45 DROP TABLE hyk_entries; 45 DROP TABLE hyk_entries PURGE;
46 DROP TABLE hyk_flow_zone_types; 46 DROP TABLE hyk_flow_zone_types PURGE;
47 DROP TABLE hyk_flow_zones; 47 DROP TABLE hyk_flow_zones PURGE;
48 DROP TABLE hyk_formations; 48 DROP TABLE hyk_formations PURGE;
49 DROP TABLE hyks; 49 DROP TABLE hyks PURGE;
50 DROP TABLE main_value_types; 50 DROP TABLE main_value_types PURGE;
51 DROP TABLE main_values; 51 DROP TABLE main_values PURGE;
52 DROP TABLE named_main_values; 52 DROP TABLE named_main_values PURGE;
53 DROP TABLE positions; 53 DROP TABLE positions PURGE;
54 DROP TABLE ranges; 54 DROP TABLE ranges PURGE;
55 DROP TABLE rivers; 55 DROP TABLE rivers PURGE;
56 DROP TABLE time_intervals; 56 DROP TABLE time_intervals PURGE;
57 DROP TABLE units; 57 DROP TABLE units PURGE;
58 DROP TABLE wst_column_q_ranges; 58 DROP TABLE wst_column_q_ranges PURGE;
59 DROP TABLE wst_column_values; 59 DROP TABLE wst_column_values PURGE;
60 DROP TABLE wst_columns; 60 DROP TABLE wst_columns PURGE;
61 DROP TABLE wst_q_ranges; 61 DROP TABLE wst_q_ranges PURGE;
62 DROP TABLE official_lines; 62 DROP TABLE official_lines PURGE;
63 DROP TABLE wsts; 63 DROP TABLE wsts PURGE;
64 DROP TABLE wst_kinds; 64 DROP TABLE wst_kinds PURGE;
65 DROP SEQUENCE ANNOTATION_TYPES_ID_SEQ; 65 DROP SEQUENCE ANNOTATION_TYPES_ID_SEQ;
66 DROP SEQUENCE ANNOTATIONS_ID_SEQ; 66 DROP SEQUENCE ANNOTATIONS_ID_SEQ;
67 DROP SEQUENCE ATTRIBUTES_ID_SEQ; 67 DROP SEQUENCE ATTRIBUTES_ID_SEQ;
68 DROP SEQUENCE CROSS_SECTION_LINES_ID_SEQ; 68 DROP SEQUENCE CROSS_SECTION_LINES_ID_SEQ;
69 DROP SEQUENCE CROSS_SECTION_POINTS_ID_SEQ; 69 DROP SEQUENCE CROSS_SECTION_POINTS_ID_SEQ;
http://dive4elements.wald.intevation.org