text: ﻿truncate table {sc}.condition_era; 
  truncate table {sc}.condition_occurrence; 
  truncate table {sc}.device_exposure; 
  truncate table {sc}.dose_era; 
  truncate table {sc}.drug_era; 
  truncate table {sc}.drug_exposure; 
  truncate table {sc}.fact_relationship; 
  truncate table {sc}.measurement; 
  truncate table {sc}.cdm_source; 
  truncate table {sc}.note; 
  truncate table {sc}.note_nlp; 
  truncate table {sc}.observation; 
  truncate table {sc}.observation_period; 
  truncate table {sc}.payer_plan_period; 
  truncate table {sc}.person; 
  truncate table {sc}.procedure_occurrence; 
  truncate table {sc}.specimen; 
  truncate table {sc}.visit_occurrence;
  truncate table {sc}.visit_detail;
  truncate table {sc}.cost;
  truncate table {sc}.cdm_source;
  truncate table {sc}.cdm_domain_meta;
  truncate table {sc}.metadata_tmp;
  truncate table {sc}.metadata;