- drop table brands;
- drop table catalogrequests;
- drop table categories;
- drop table cust_notes;
- drop table customers;
- drop table customerterms;
- drop table distributor_orders;
- drop table distributor_orders_tmp;
- drop table distributor_purchases;
- drop table distributors;
- drop table drop_list_dump;
- drop table dropstates;
- drop table favorites;
- drop table item_dimensions;
- drop table item_links;
- drop table item_loc;
- drop table line_items;
- drop table modifiedcustomers;
- drop table new_items;
- drop table order_header;
- drop table pricinglevels;
- drop table pricingtable;
- drop table pricingtable_backup;
- drop table product_meta;
- drop table products;
- drop table publishing;
- drop table purchase;
- drop table purchase_line;
- drop table route_alternates;
- drop table route_date;
- drop table route_schedules;
- drop table routes;
- drop table sales;
- drop table specials;
- drop table state_list;
- drop table status;
- drop table upc2;
- drop table upsshippable;
- drop table vend_item;
- drop table vend_promo_item;
- drop table vendor;
- drop table vendor_contact;
- drop table vendor_products;
- drop table zipcodes;
- drop sequence catalogrequests_id_seq;
- drop sequence customers_id_seq ;
- drop sequence item_dimensions_id_seq;
- drop sequence item_links_id_seq ;
- drop sequence item_loc_id_seq ;
- drop sequence line_items_id_seq ;
- drop sequence order_header_id_seq ;
- drop sequence pricinglevels_id_seq ;
- drop sequence pricingtable_id_seq ;
- drop sequence product_meta_id_seq ;
- drop sequence products_id_seq ;
- drop sequence purchase_id_seq ;
- drop sequence purchase_line_id_seq ;
- drop sequence vendor_contact_id_seq ;
- drop sequence vendor_id_seq ;
- drop sequence vendor_products_id_seq;