Project

General

Profile

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 location CASCADE;
35
TRUNCATE locationevent CASCADE;
36
TRUNCATE locationeventcontributor CASCADE;
37
TRUNCATE locationeventsynonym 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 place CASCADE;
45
TRUNCATE plantconcept CASCADE;
46
TRUNCATE plantcorrelation CASCADE;
47
TRUNCATE plantlineage CASCADE;
48
TRUNCATE plantname CASCADE;
49
TRUNCATE plantstatus CASCADE;
50
TRUNCATE plantusage 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 stem 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;
86
TRUNCATE voucher CASCADE;
(10-10/10)