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 morphospecies 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 plant CASCADE;
45
TRUNCATE plantconcept CASCADE;
46
TRUNCATE plantcorrelation CASCADE;
47
TRUNCATE plantlineage CASCADE;
48
TRUNCATE plantname CASCADE;
49
TRUNCATE plantobservation CASCADE;
50
TRUNCATE plantstatus CASCADE;
51
TRUNCATE planttag CASCADE;
52
TRUNCATE plantusage CASCADE;
53
TRUNCATE project CASCADE;
54
TRUNCATE projectcontributor CASCADE;
55
TRUNCATE reference CASCADE;
56
TRUNCATE referencealtident CASCADE;
57
TRUNCATE referencecontributor CASCADE;
58
TRUNCATE referencejournal CASCADE;
59
TRUNCATE referenceparty CASCADE;
60
TRUNCATE revision CASCADE;
61
TRUNCATE role CASCADE;
62
TRUNCATE sizeclass CASCADE;
63
TRUNCATE soilobs CASCADE;
64
TRUNCATE soiltaxon CASCADE;
65
TRUNCATE specimen CASCADE;
66
TRUNCATE specimenreplicate CASCADE;
67
TRUNCATE stemobservation CASCADE;
68
TRUNCATE stratum CASCADE;
69
TRUNCATE stratummethod CASCADE;
70
TRUNCATE stratumtype CASCADE;
71
TRUNCATE taxonalt CASCADE;
72
TRUNCATE taxondetermination CASCADE;
73
TRUNCATE taxonoccurrence CASCADE;
74
TRUNCATE telephone CASCADE;
75
TRUNCATE temptbl_std_commnames CASCADE;
76
TRUNCATE temptbl_std_plantnames CASCADE;
77
TRUNCATE trait CASCADE;
78
TRUNCATE usercertification CASCADE;
79
TRUNCATE userdataset CASCADE;
80
TRUNCATE userdatasetitem CASCADE;
81
TRUNCATE userdefined CASCADE;
82
TRUNCATE usernotify CASCADE;
83
TRUNCATE userpermission CASCADE;
84
TRUNCATE userpreference CASCADE;
85
TRUNCATE userquery CASCADE;
86
TRUNCATE userrecordowner CASCADE;
87
TRUNCATE userregionalexp CASCADE;
88
TRUNCATE usr CASCADE;
89
TRUNCATE voucher CASCADE;
(14-14/14)