1
|
TRUNCATE address CASCADE;
|
2
|
TRUNCATE aggregateoccurrence CASCADE;
|
3
|
TRUNCATE aux_role CASCADE;
|
4
|
TRUNCATE classcontributor CASCADE;
|
5
|
TRUNCATE commclass CASCADE;
|
6
|
TRUNCATE commconcept CASCADE;
|
7
|
TRUNCATE commcorrelation CASCADE;
|
8
|
TRUNCATE commdetermination CASCADE;
|
9
|
TRUNCATE commlineage CASCADE;
|
10
|
TRUNCATE commname CASCADE;
|
11
|
TRUNCATE commstatus CASCADE;
|
12
|
TRUNCATE commusage CASCADE;
|
13
|
TRUNCATE coverindex CASCADE;
|
14
|
TRUNCATE covermethod CASCADE;
|
15
|
TRUNCATE dba_confidentialitystatus CASCADE;
|
16
|
TRUNCATE dba_cookie CASCADE;
|
17
|
TRUNCATE dba_cookielabels CASCADE;
|
18
|
TRUNCATE dba_datacache CASCADE;
|
19
|
TRUNCATE dba_datamodelversion CASCADE;
|
20
|
TRUNCATE dba_dbstatstime CASCADE;
|
21
|
TRUNCATE dba_fielddescription CASCADE;
|
22
|
TRUNCATE dba_fieldlist CASCADE;
|
23
|
TRUNCATE dba_onerow CASCADE;
|
24
|
TRUNCATE dba_preassignacccode CASCADE;
|
25
|
TRUNCATE dba_tabledescription CASCADE;
|
26
|
TRUNCATE dba_xmlcache CASCADE;
|
27
|
TRUNCATE definedvalue CASCADE;
|
28
|
TRUNCATE disturbanceobs CASCADE;
|
29
|
TRUNCATE embargo CASCADE;
|
30
|
TRUNCATE graphic CASCADE;
|
31
|
TRUNCATE individualplant CASCADE;
|
32
|
TRUNCATE keywords CASCADE;
|
33
|
TRUNCATE keywords_extra CASCADE;
|
34
|
TRUNCATE namedplace CASCADE;
|
35
|
TRUNCATE namedplacecorrelation CASCADE;
|
36
|
TRUNCATE note CASCADE;
|
37
|
TRUNCATE notelink CASCADE;
|
38
|
TRUNCATE party CASCADE;
|
39
|
TRUNCATE partymember CASCADE;
|
40
|
TRUNCATE place CASCADE;
|
41
|
TRUNCATE plantconcept CASCADE;
|
42
|
TRUNCATE plantcorrelation CASCADE;
|
43
|
TRUNCATE plantlineage CASCADE;
|
44
|
TRUNCATE plantname CASCADE;
|
45
|
TRUNCATE plantstatus CASCADE;
|
46
|
TRUNCATE plantusage CASCADE;
|
47
|
TRUNCATE plot CASCADE;
|
48
|
TRUNCATE plotevent CASCADE;
|
49
|
TRUNCATE ploteventcontributor CASCADE;
|
50
|
TRUNCATE ploteventsynonym CASCADE;
|
51
|
TRUNCATE project CASCADE;
|
52
|
TRUNCATE projectcontributor CASCADE;
|
53
|
TRUNCATE reference CASCADE;
|
54
|
TRUNCATE referencealtident CASCADE;
|
55
|
TRUNCATE referencecontributor CASCADE;
|
56
|
TRUNCATE referencejournal CASCADE;
|
57
|
TRUNCATE referenceparty CASCADE;
|
58
|
TRUNCATE revision CASCADE;
|
59
|
TRUNCATE sizeclass CASCADE;
|
60
|
TRUNCATE soilobs CASCADE;
|
61
|
TRUNCATE soiltaxon CASCADE;
|
62
|
TRUNCATE specimen CASCADE;
|
63
|
TRUNCATE stemobservation CASCADE;
|
64
|
TRUNCATE stratum CASCADE;
|
65
|
TRUNCATE stratummethod CASCADE;
|
66
|
TRUNCATE stratumtype CASCADE;
|
67
|
TRUNCATE taxonalt CASCADE;
|
68
|
TRUNCATE taxonbin CASCADE;
|
69
|
TRUNCATE taxondetermination CASCADE;
|
70
|
TRUNCATE taxonoccurrence CASCADE;
|
71
|
TRUNCATE telephone CASCADE;
|
72
|
TRUNCATE temptbl_std_commnames CASCADE;
|
73
|
TRUNCATE temptbl_std_plantnames CASCADE;
|
74
|
TRUNCATE trait CASCADE;
|
75
|
TRUNCATE usercertification CASCADE;
|
76
|
TRUNCATE userdataset CASCADE;
|
77
|
TRUNCATE userdatasetitem CASCADE;
|
78
|
TRUNCATE userdefined CASCADE;
|
79
|
TRUNCATE usernotify CASCADE;
|
80
|
TRUNCATE userpermission CASCADE;
|
81
|
TRUNCATE userpreference CASCADE;
|
82
|
TRUNCATE userquery CASCADE;
|
83
|
TRUNCATE userrecordowner CASCADE;
|
84
|
TRUNCATE userregionalexp CASCADE;
|
85
|
TRUNCATE usr CASCADE;
|