TRUNCATE address CASCADE;
TRUNCATE aux_role CASCADE;
TRUNCATE classcontributor CASCADE;
TRUNCATE commclass CASCADE;
TRUNCATE commconcept CASCADE;
TRUNCATE commcorrelation CASCADE;
TRUNCATE comminterpretation 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 namedplace CASCADE;
TRUNCATE namedplacecorrelation CASCADE;
TRUNCATE note CASCADE;
TRUNCATE notelink CASCADE;
TRUNCATE observation 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 stemcount CASCADE;
TRUNCATE stemlocation CASCADE;
TRUNCATE stratum CASCADE;
TRUNCATE stratummethod CASCADE;
TRUNCATE stratumtype CASCADE;
TRUNCATE taxonalt CASCADE;
TRUNCATE taxonimportance CASCADE;
TRUNCATE taxoninterpretation CASCADE;
TRUNCATE taxonobservation 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;