TRUNCATE address CASCADE;

TRUNCATE aux_role CASCADE;

TRUNCATE classcontributor CASCADE;

TRUNCATE collection CASCADE;

TRUNCATE collectiveobservation 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 individualplant CASCADE;

TRUNCATE keywords CASCADE;

TRUNCATE keywords_extra CASCADE;

TRUNCATE namedplace CASCADE;

TRUNCATE namedplacecorrelation CASCADE;

TRUNCATE note CASCADE;

TRUNCATE notelink CASCADE;

TRUNCATE plotevent CASCADE;

TRUNCATE observationcontributor CASCADE;

TRUNCATE observationsynonym CASCADE;

TRUNCATE party CASCADE;

TRUNCATE partymember CASCADE;

TRUNCATE place CASCADE;

TRUNCATE plantconcept CASCADE;

TRUNCATE plantcorrelation CASCADE;

TRUNCATE plantlineage CASCADE;

TRUNCATE plantname CASCADE;

TRUNCATE plantstatus CASCADE;

TRUNCATE plantusage CASCADE;

TRUNCATE plot 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 soilobs CASCADE;

TRUNCATE soiltaxon CASCADE;

TRUNCATE stemobservation CASCADE;

TRUNCATE stratum CASCADE;

TRUNCATE stratummethod CASCADE;

TRUNCATE stratumtype CASCADE;

TRUNCATE taxonalt CASCADE;

TRUNCATE taxonbin CASCADE;

TRUNCATE taxondetermination CASCADE;

TRUNCATE taxonoccurrence CASCADE;

TRUNCATE telephone CASCADE;

TRUNCATE temptbl_std_commnames CASCADE;

TRUNCATE temptbl_std_plantnames 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;