TRUNCATE address CASCADE;
TRUNCATE aggregateoccurrence CASCADE;
TRUNCATE classcontributor CASCADE;
TRUNCATE commclass CASCADE;
TRUNCATE commconcept CASCADE;
TRUNCATE commcorrelation CASCADE;
TRUNCATE commdetermination CASCADE;
TRUNCATE commlineage CASCADE;
TRUNCATE commname CASCADE;
TRUNCATE commstatus CASCADE;
TRUNCATE commusage CASCADE;
TRUNCATE coverindex CASCADE;
TRUNCATE covermethod CASCADE;
TRUNCATE dba_confidentialitystatus CASCADE;
TRUNCATE dba_cookie CASCADE;
TRUNCATE dba_cookielabels CASCADE;
TRUNCATE dba_datacache CASCADE;
TRUNCATE dba_datamodelversion CASCADE;
TRUNCATE dba_dbstatstime CASCADE;
TRUNCATE dba_fielddescription CASCADE;
TRUNCATE dba_fieldlist CASCADE;
TRUNCATE dba_onerow CASCADE;
TRUNCATE dba_preassignacccode CASCADE;
TRUNCATE dba_tabledescription CASCADE;
TRUNCATE dba_xmlcache CASCADE;
TRUNCATE definedvalue CASCADE;
TRUNCATE disturbanceobs CASCADE;
TRUNCATE embargo CASCADE;
TRUNCATE graphic CASCADE;
TRUNCATE keywords CASCADE;
TRUNCATE keywords_extra CASCADE;
TRUNCATE location CASCADE;
TRUNCATE locationevent CASCADE;
TRUNCATE locationeventcontributor CASCADE;
TRUNCATE locationeventsynonym CASCADE;
TRUNCATE locationplace CASCADE;
TRUNCATE namedplace CASCADE;
TRUNCATE namedplacecorrelation CASCADE;
TRUNCATE note CASCADE;
TRUNCATE notelink CASCADE;
TRUNCATE party CASCADE;
TRUNCATE partymember CASCADE;
TRUNCATE plant CASCADE;
TRUNCATE plantconcept CASCADE;
TRUNCATE plantcorrelation CASCADE;
TRUNCATE plantlineage CASCADE;
TRUNCATE plantname CASCADE;
TRUNCATE plantobservation CASCADE;
TRUNCATE plantstatus CASCADE;
TRUNCATE planttag CASCADE;
TRUNCATE plantusage CASCADE;
TRUNCATE project CASCADE;
TRUNCATE projectcontributor CASCADE;
TRUNCATE reference CASCADE;
TRUNCATE referencealtident CASCADE;
TRUNCATE referencecontributor CASCADE;
TRUNCATE referencejournal CASCADE;
TRUNCATE referenceparty CASCADE;
TRUNCATE revision CASCADE;
TRUNCATE role CASCADE;
TRUNCATE sizeclass CASCADE;
TRUNCATE soilobs CASCADE;
TRUNCATE soiltaxon CASCADE;
TRUNCATE specimen CASCADE;
TRUNCATE specimenreplicate CASCADE;
TRUNCATE stemobservation CASCADE;
TRUNCATE stratum CASCADE;
TRUNCATE stratummethod CASCADE;
TRUNCATE stratumtype CASCADE;
TRUNCATE taxonalt CASCADE;
TRUNCATE taxonbinmethod CASCADE;
TRUNCATE taxondetermination CASCADE;
TRUNCATE taxonoccurrence CASCADE;
TRUNCATE telephone CASCADE;
TRUNCATE temptbl_std_commnames CASCADE;
TRUNCATE temptbl_std_plantnames CASCADE;
TRUNCATE trait CASCADE;
TRUNCATE usercertification CASCADE;
TRUNCATE userdataset CASCADE;
TRUNCATE userdatasetitem CASCADE;
TRUNCATE userdefined CASCADE;
TRUNCATE usernotify CASCADE;
TRUNCATE userpermission CASCADE;
TRUNCATE userpreference CASCADE;
TRUNCATE userquery CASCADE;
TRUNCATE userrecordowner CASCADE;
TRUNCATE userregionalexp CASCADE;
TRUNCATE usr CASCADE;
TRUNCATE voucher CASCADE;