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 keywords CASCADE;
31
TRUNCATE keywords_extra CASCADE;
32
TRUNCATE location CASCADE;
33
TRUNCATE locationevent CASCADE;
34
TRUNCATE locationeventcontributor CASCADE;
35
TRUNCATE locationeventsynonym CASCADE;
36
TRUNCATE locationplace CASCADE;
37
TRUNCATE namedplace CASCADE;
38
TRUNCATE namedplacecorrelation CASCADE;
39
TRUNCATE note CASCADE;
40
TRUNCATE notelink CASCADE;
41
TRUNCATE party CASCADE;
42
TRUNCATE partymember CASCADE;
43
TRUNCATE plant CASCADE;
44
TRUNCATE plantconcept CASCADE;
45
TRUNCATE plantcorrelation CASCADE;
46
TRUNCATE plantlineage CASCADE;
47
TRUNCATE plantname CASCADE;
48
TRUNCATE plantobservation CASCADE;
49
TRUNCATE plantstatus CASCADE;
50
TRUNCATE planttag CASCADE;
51
TRUNCATE plantusage CASCADE;
52
TRUNCATE project CASCADE;
53
TRUNCATE projectcontributor CASCADE;
54
TRUNCATE reference CASCADE;
55
TRUNCATE referencealtident CASCADE;
56
TRUNCATE referencecontributor CASCADE;
57
TRUNCATE referencejournal CASCADE;
58
TRUNCATE referenceparty CASCADE;
59
TRUNCATE revision CASCADE;
60
TRUNCATE role CASCADE;
61
TRUNCATE sizeclass CASCADE;
62
TRUNCATE soilobs CASCADE;
63
TRUNCATE soiltaxon CASCADE;
64
TRUNCATE specimen CASCADE;
65
TRUNCATE specimenreplicate CASCADE;
66
TRUNCATE stemobservation CASCADE;
67
TRUNCATE stratum CASCADE;
68
TRUNCATE stratummethod CASCADE;
69
TRUNCATE stratumtype CASCADE;
70
TRUNCATE taxonalt CASCADE;
71
TRUNCATE taxondetermination CASCADE;
72
TRUNCATE taxonoccurrence CASCADE;
73
TRUNCATE telephone CASCADE;
74
TRUNCATE temptbl_std_commnames CASCADE;
75
TRUNCATE temptbl_std_plantnames CASCADE;
76
TRUNCATE trait CASCADE;
77
TRUNCATE usercertification CASCADE;
78
TRUNCATE userdataset CASCADE;
79
TRUNCATE userdatasetitem CASCADE;
80
TRUNCATE userdefined CASCADE;
81
TRUNCATE usernotify CASCADE;
82
TRUNCATE userpermission CASCADE;
83
TRUNCATE userpreference CASCADE;
84
TRUNCATE userquery CASCADE;
85
TRUNCATE userrecordowner CASCADE;
86
TRUNCATE userregionalexp CASCADE;
87
TRUNCATE usr CASCADE;
88
TRUNCATE voucher CASCADE;
(12-12/12)