drops

drop.sql

DROP TABLE prod_b.0023084_160910150852091_interpreted;
DROP TABLE prod_b.0023084_160910150852091_verbatim;
DROP TABLE prod_b.0035467_160910150852091;
DROP TABLE prod_b.0035467_160910150852091_citation;
DROP TABLE prod_b.0035499_160910150852091;
DROP TABLE prod_b.0035499_160910150852091_citation;
DROP TABLE prod_b.0040768_160910150852091_interpreted;
DROP TABLE prod_b.0040768_160910150852091_verbatim;
DROP TABLE prod_b.0040789_160910150852091_interpreted;
DROP TABLE prod_b.0040789_160910150852091_verbatim;
DROP TABLE prod_b.0041192_160910150852091_interpreted;
DROP TABLE prod_b.0041192_160910150852091_verbatim;
DROP TABLE prod_b.0041195_160910150852091_interpreted;
DROP TABLE prod_b.0041195_160910150852091_verbatim;
DROP TABLE prod_b.0043392_160910150852091_citation;
DROP TABLE prod_b.0043392_160910150852091_interpreted;
DROP TABLE prod_b.0043392_160910150852091_multimedia;
DROP TABLE prod_b.0043392_160910150852091_verbatim;
DROP TABLE prod_b.0043396_160910150852091_citation;
DROP TABLE prod_b.0043396_160910150852091_interpreted;
DROP TABLE prod_b.0043396_160910150852091_multimedia;
DROP TABLE prod_b.0043396_160910150852091_verbatim;
DROP TABLE prod_b.0043398_160910150852091_citation;
DROP TABLE prod_b.0043398_160910150852091_interpreted;
DROP TABLE prod_b.0043398_160910150852091_multimedia;
DROP TABLE prod_b.0043398_160910150852091_verbatim;
DROP TABLE prod_b.0044273_160910150852091_interpreted;
DROP TABLE prod_b.0044273_160910150852091_verbatim;
DROP TABLE prod_b.0048805_160910150852091;
DROP TABLE prod_b.0048805_160910150852091_citation;
DROP TABLE prod_b.0050782_160910150852091_interpreted;
DROP TABLE prod_b.0050782_160910150852091_verbatim;
DROP TABLE prod_b.0050948_160910150852091;
DROP TABLE prod_b.0050948_160910150852091_citation;
DROP TABLE prod_b.0050957_160910150852091;
DROP TABLE prod_b.0050957_160910150852091_citation;
DROP TABLE prod_b.0050959_160910150852091;
DROP TABLE prod_b.0050959_160910150852091_citation;
DROP TABLE prod_b.0051098_160910150852091_interpreted;
DROP TABLE prod_b.0051098_160910150852091_verbatim;
DROP TABLE prod_b.0051201_160910150852091;
DROP TABLE prod_b.0051716_160910150852091_interpreted;
DROP TABLE prod_b.0051716_160910150852091_verbatim;
DROP TABLE prod_b.0051720_160910150852091_interpreted;
DROP TABLE prod_b.0051720_160910150852091_verbatim;
DROP TABLE prod_b.0051733_160910150852091_interpreted;
DROP TABLE prod_b.0051733_160910150852091_verbatim;
DROP TABLE prod_b.0051737_160910150852091_interpreted;
DROP TABLE prod_b.0051737_160910150852091_verbatim;
DROP TABLE prod_b.0051813_160910150852091_interpreted;
DROP TABLE prod_b.0051813_160910150852091_verbatim;
DROP TABLE prod_b.0053553_160910150852091;
DROP TABLE prod_b.0053553_160910150852091_citation;
DROP TABLE prod_b.0053603_160910150852091;
DROP TABLE prod_b.0053603_160910150852091_citation;
DROP TABLE prod_b.0053640_160910150852091_interpreted;
DROP TABLE prod_b.0053640_160910150852091_verbatim;
DROP TABLE prod_b.0053670_160910150852091_interpreted;
DROP TABLE prod_b.0053670_160910150852091_verbatim;
DROP TABLE prod_b.0053674_160910150852091_interpreted;
DROP TABLE prod_b.0053674_160910150852091_verbatim;
DROP TABLE prod_b.0053687_160910150852091_interpreted;
DROP TABLE prod_b.0053687_160910150852091_verbatim;
DROP TABLE prod_b.0054688_160910150852091_interpreted;
DROP TABLE prod_b.0054688_160910150852091_verbatim;
DROP TABLE prod_b.0054690_160910150852091_interpreted;
DROP TABLE prod_b.0054690_160910150852091_verbatim;
DROP TABLE prod_b.0054695_160910150852091_interpreted;
DROP TABLE prod_b.0054695_160910150852091_verbatim;
DROP TABLE prod_b.0054698_160910150852091_interpreted;
DROP TABLE prod_b.0054698_160910150852091_verbatim;
DROP TABLE prod_b.0054702_160910150852091_interpreted;
DROP TABLE prod_b.0054702_160910150852091_verbatim;
DROP TABLE prod_b.0054705_160910150852091_interpreted;
DROP TABLE prod_b.0054705_160910150852091_verbatim;
DROP TABLE prod_b.0054707_160910150852091_interpreted;
DROP TABLE prod_b.0054707_160910150852091_verbatim;
DROP TABLE prod_b.0054710_160910150852091_interpreted;
DROP TABLE prod_b.0054710_160910150852091_verbatim;
DROP TABLE prod_b.0054716_160910150852091_interpreted;
DROP TABLE prod_b.0054716_160910150852091_verbatim;
DROP TABLE prod_b.0055008_160910150852091;
DROP TABLE prod_b.0055008_160910150852091_citation;
DROP TABLE prod_b.0055010_160910150852091;
DROP TABLE prod_b.0055010_160910150852091_citation;
DROP TABLE prod_b.0055030_160910150852091;
DROP TABLE prod_b.0055030_160910150852091_citation;
DROP TABLE prod_b.0055483_160910150852091_interpreted;
DROP TABLE prod_b.0055483_160910150852091_verbatim;
DROP TABLE prod_b.0055484_160910150852091_interpreted;
DROP TABLE prod_b.0055484_160910150852091_verbatim;
DROP TABLE prod_b.0055486_160910150852091_interpreted;
DROP TABLE prod_b.0055486_160910150852091_verbatim;
DROP TABLE prod_b.0055494_160910150852091_interpreted;
DROP TABLE prod_b.0055494_160910150852091_verbatim;
DROP TABLE prod_b.0055692_160910150852091_interpreted;
DROP TABLE prod_b.0055692_160910150852091_verbatim;
DROP TABLE prod_b.0058252_160910150852091_interpreted;
DROP TABLE prod_b.0058252_160910150852091_verbatim;
DROP TABLE prod_b.0058254_160910150852091_interpreted;
DROP TABLE prod_b.0058254_160910150852091_verbatim;
DROP TABLE prod_b.0058257_160910150852091_interpreted;
DROP TABLE prod_b.0058257_160910150852091_verbatim;
DROP TABLE prod_b.0058260_160910150852091_interpreted;
DROP TABLE prod_b.0058260_160910150852091_verbatim;
DROP TABLE prod_b.0058293_160910150852091_interpreted;
DROP TABLE prod_b.0058293_160910150852091_verbatim;
DROP TABLE prod_b.0058692_160910150852091_interpreted;
DROP TABLE prod_b.0058692_160910150852091_verbatim;
DROP TABLE prod_b.0060865_160910150852091_interpreted;
DROP TABLE prod_b.0060865_160910150852091_verbatim;
DROP TABLE prod_b.interp_test;
DROP TABLE prod_b.interp_test2;
DROP TABLE prod_b.occurrence_avro;
DROP TABLE prod_b.occurrence_hbase;
DROP TABLE prod_b.occurrence_hdfs;
DROP TABLE prod_b.occurrence_hdfs_sep15;
DROP TABLE prod_b.occurrence_multimedia;
DROP TABLE prod_b.type_specimen_ids;
DROP TABLE prod_b.type_specimen_taxa;