How to drop tables for HammerDB TPC-C on SQL Server

From the SQL Window of SQL*Server. Issue these commands to drop the tables and procedures created by HammerDB. This will allow you (for instance) to re-create the database, or create a new database with more warehouses (larger size) while retaining the same name/DB layout.

USE [TPCC]
DROP TABLE [dbo]. [CUSTOMER]
DROP TABLE [dbo]. [DISTRICT]
DROP TABLE [dbo]. [HISTORY]
DROP TABLE [dbo]. [ITEM]
DROP TABLE [dbo]. [NEW_ORDER]
DROP TABLE [dbo]. [ORDER_LINE]
DROP TABLE [dbo]. [ORDERS]
DROP TABLE [dbo]. [STOCK]
DROP TABLE [dbo]. [WAREHOUSE]
GO


USE [TPCC]
DROP PROCEDURE [dbo]. [DELIVERY]
DROP PROCEDURE [dbo]. [NEWORD]
DROP PROCEDURE [dbo]. [OSTAT]
DROP PROCEDURE [dbo]. [PAYMENT]
DROP PROCEDURE [dbo]. [SLEV]
GO

Leave a Comment