-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathdrop_all_tables_tb.sql
48 lines (48 loc) · 1.92 KB
/
drop_all_tables_tb.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
drop table "tb_atc_molecule" cascade;
drop table "tb_category" cascade;
drop table "tb_chemical_space" cascade;
drop table "tb_ctfaers_drug2event" cascade;
drop table "tb_ctfaers_drug_summary" cascade;
drop table "tb_ctfaers_event_summary" cascade;
drop table "tb_chemical_space_neighbour" cascade;
drop table "tb_ctfaers_reporter_codes" cascade;
drop table "tb_ctfaers_outcome_codes" cascade;
drop table "tb_chemical_space_metabolite" cascade;
drop table "tb_ctfaers_role_codes" cascade;
drop table "tb_ctfaers_timespan" cascade;
drop table "tb_drug_thesaurus" cascade;
drop table "tb_drug_thesaurus_clean" cascade;
drop table "tb_tlink_subst_xpharm" cascade;
drop table "tb_model" cascade;
drop table "tb_medchem_molecule" cascade;
drop table "tb_medchem_scaffold" cascade;
drop table "tb_medchem_substituents" cascade;
drop table "tb_molecule_metabolite" cascade;
drop table "tb_slink_chemical_space_fragment" cascade;
drop table "tb_pathway" cascade;
drop table "tb_slink_chemical_space" cascade;
drop table "tb_model_network" cascade;
drop table "tb_tlink_chemical_space" cascade;
drop table "tb_tlink_chemical_space_subst_sas" cascade;
drop table "tb_tlink" cascade;
drop table "tb_tlink_chemical_space_subst_xpharm" cascade;
drop table "tb_umls_category" cascade;
drop table "tb_target_thesaurus" cascade;
drop table "tb_target_family" cascade;
drop table "tb_tlink_subst_sas" cascade;
drop table "tb_ctfaers_report_drug" cascade;
drop table "tb_ctfaers_report" cascade;
drop table "tb_atc_tree" cascade;
drop table "tb_user" cascade;
drop table "tb_job" cascade;
drop table "tb_job_message" cascade;
drop table "tb_job_model" cascade;
drop table "tb_job_molecule" cascade;
drop table "tb_model_image" cascade;
drop table "tb_molecule" cascade;
drop table "tb_target" cascade;
drop table "tb_family" cascade;
drop table "tb_umls" cascade;
drop table "tb_molecule_neighbour" cascade;
drop table "tb_slink" cascade;
drop table "tb_slink_fragment" cascade;