DELETE AccountReceivableHistory DELETE AccountReceivable ---DELETE Customer DELETE TransactionEntry DELETE TenderTotals DELETE TenderEntry DELETE TaxTotals DELETE TaxEntry DELETE Journal DELETE [Transaction] DELETE Batch DELETE OrderHistory DELETE NonTenderTransaction DELETE TimeCard DELETE DailySales DELETE InventoryTransferLog DELETE OrderEntry DELETE [Order] DELETE PurchaseOrderEntryDetail DELETE PurchaseOrderEntry DELETE PurchaseOrder --- UPDATE PurchaseOrder SET PONumber = '0000001' DELETE ItemClassComponent DELETE ItemClass DELETE KIT DELETE Serial DELETE VoucherEntry DELETE VOUCHER UPDATE CUSTOMER SET ACCOUNTBALANCE = 0 UPDATE CUSTOMER SET TOTALSALES = 0 UPDATE CUSTOMER SET TOTALSAVINGS = 0 UPDATE CUSTOMER SET TOTALVISITS = 0 UPDATE CUSTOMER SET LASTCLOSINGDATE = '1/01/1900' UPDATE CUSTOMER SET LASTSTARTINGDATE = '12/30/1899' UPDATE CUSTOMER SET LASTCLOSINGBALANCE = 0 GO DBCC SHRINKDATABASE (mydatabase, 10);