Use the following SQL to drop the tables and indexes in the HammerDB TPC-H schema, so that you can re-load it.

use tpch;
drop table lineitem;
drop table orders;
drop table partsupp;
drop table part;
drop table supplier;
drop table customer;
drop table nation;
drop table region;
GO