drop_tables.sql

SET FOREIGN_KEY_CHECKS = 0;
DROP TABLE IF EXISTS CDM_SOURCE;                 
 DROP TABLE IF EXISTS COHORT;                     
 DROP TABLE IF EXISTS COHORT_DEFINITION;          
 DROP TABLE IF EXISTS CONCEPT;                    
 DROP TABLE IF EXISTS CONCEPT_ANCESTOR;           
 DROP TABLE IF EXISTS CONCEPT_CLASS;              
 DROP TABLE IF EXISTS CONCEPT_RELATIONSHIP;       
 DROP TABLE IF EXISTS CONCEPT_SYNONYM;            
 DROP TABLE IF EXISTS CONDITION_ERA;              
 DROP TABLE IF EXISTS CONDITION_OCCURRENCE;       
 DROP TABLE IF EXISTS COST;                       
 DROP TABLE IF EXISTS DEATH;                      
 DROP TABLE IF EXISTS DEVICE_EXPOSURE;            
 DROP TABLE IF EXISTS DOMAIN;                     
 DROP TABLE IF EXISTS DOSE_ERA;                   
 DROP TABLE IF EXISTS DRUG_ERA;                   
 DROP TABLE IF EXISTS DRUG_EXPOSURE;              
 DROP TABLE IF EXISTS DRUG_STRENGTH;              
 DROP TABLE IF EXISTS EPISODE;                    
 DROP TABLE IF EXISTS EPISODE_EVENT;              
 DROP TABLE IF EXISTS FACT_RELATIONSHIP;          
 DROP TABLE IF EXISTS LOCATION;                   
 DROP TABLE IF EXISTS MEASUREMENT;                
 DROP TABLE IF EXISTS METADATA;                   
 DROP TABLE IF EXISTS NOTE;                       
 DROP TABLE IF EXISTS NOTE_NLP;                   
 DROP TABLE IF EXISTS OBSERVATION;                
 DROP TABLE IF EXISTS OBSERVATION_PERIOD;         
 DROP TABLE IF EXISTS PAYER_PLAN_PERIOD;          
 DROP TABLE IF EXISTS PERSON;                     
 DROP TABLE IF EXISTS PROCEDURE_OCCURRENCE;       
 DROP TABLE IF EXISTS PROVIDER;                   
 DROP TABLE IF EXISTS RELATIONSHIP;               
 DROP TABLE IF EXISTS SOURCE_TO_CONCEPT_MAP;      
 DROP TABLE IF EXISTS SPECIMEN;                   
 DROP TABLE IF EXISTS VISIT_DETAIL;               
 DROP TABLE IF EXISTS VISIT_OCCURRENCE;           
 DROP TABLE IF EXISTS VOCABULARY;
SET FOREIGN_KEY_CHECKS = 1;