Project

General

Profile

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