text: 
  if object_id('@cdm_schema.care_site', 'U')             is not null truncate table @cdm_schema.care_site;
  if object_id('@cdm_schema.cdm_source', 'U')            is not null truncate table @cdm_schema.cdm_source;
  if object_id('@cdm_schema.cohort', 'U')                is not null truncate table @cdm_schema.cohort;
  if object_id('@cdm_schema.cohort_attribute', 'U')      is not null truncate table @cdm_schema.cohort_attribute;
  if object_id('@cdm_schema.condition_era', 'U')         is not null truncate table @cdm_schema.condition_era;
  if object_id('@cdm_schema.condition_occurrence', 'U')  is not null truncate table @cdm_schema.condition_occurrence;
  if object_id('@cdm_schema.cost', 'U')                  is not null truncate table @cdm_schema.cost;
  if object_id('@cdm_schema.death', 'U')                 is not null truncate table @cdm_schema.death;
  if object_id('@cdm_schema.device_exposure', 'U')       is not null truncate table @cdm_schema.device_exposure;
  if object_id('@cdm_schema.dose_era', 'U')              is not null truncate table @cdm_schema.dose_era;
  if object_id('@cdm_schema.drug_era', 'U')              is not null truncate table @cdm_schema.drug_era;
  if object_id('@cdm_schema.drug_exposure', 'U')         is not null truncate table @cdm_schema.drug_exposure;
  if object_id('@cdm_schema.fact_relationship', 'U')     is not null truncate table @cdm_schema.fact_relationship;
  if object_id('@cdm_schema.location', 'U')              is not null truncate table @cdm_schema.location;
  if object_id('@cdm_schema.measurement', 'U')           is not null truncate table @cdm_schema.measurement;
  if object_id('@cdm_schema.metadata', 'U')              is not null truncate table @cdm_schema.metadata;
  if object_id('@cdm_schema.note', 'U')                  is not null truncate table @cdm_schema.note;
  if object_id('@cdm_schema.note_nlp', 'U')              is not null truncate table @cdm_schema.note_nlp;
  if object_id('@cdm_schema.observation', 'U')           is not null truncate table @cdm_schema.observation;
  if object_id('@cdm_schema.observation_period', 'U')    is not null truncate table @cdm_schema.observation_period;
  if object_id('@cdm_schema.payer_plan_period', 'U')     is not null truncate table @cdm_schema.payer_plan_period;
  if object_id('@cdm_schema.person', 'U')                is not null truncate table @cdm_schema.person;
  if object_id('@cdm_schema.procedure_occurrence', 'U')  is not null truncate table @cdm_schema.procedure_occurrence;
  if object_id('@cdm_schema.provider', 'U')              is not null truncate table @cdm_schema.provider;
  if object_id('@cdm_schema.specimen', 'U')              is not null truncate table @cdm_schema.specimen;
  if object_id('@cdm_schema.visit_detail', 'U')          is not null truncate table @cdm_schema.visit_detail;
  if object_id('@cdm_schema.visit_occurrence', 'U')      is not null truncate table @cdm_schema.visit_occurrence;
  