Script for DB Cleaning - New Deployment (Cleaning and reseed the tables)

DELETE FROM Request;
DBCC CHECKIDENT('[TestDB].[dbo].[Request]', RESEED, 0);

DELETE FROM Trade;
DBCC CHECKIDENT('[TestDB].[dbo].[Trade]', RESEED, 0);

DELETE FROM TradeLine;
DBCC CHECKIDENT('[TestDB].[dbo].[TradeLine]', RESEED, 0);

DELETE FROM Sale;
DBCC CHECKIDENT('[TestDB].[dbo].[Sale]', RESEED, 0);

DELETE FROM SaleLine;
DBCC CHECKIDENT('[TestDB].[dbo].[SaleLine]', RESEED, 0);

DELETE FROM SalePayment;
DBCC CHECKIDENT('[TestDB].[dbo].[SalePayment]', RESEED, 0);

DELETE FROM Payment;
DBCC CHECKIDENT('[TestDB].[dbo].[Payment]', RESEED, 0);

DELETE FROM PaymentCash;
DBCC CHECKIDENT('[TestDB].[dbo].[PaymentCash]', RESEED, 0);

DELETE FROM PaymentTradeIn;
DBCC CHECKIDENT('[TestDB].[dbo].[PaymentTradeIn]', RESEED, 0);

DELETE FROM PaymentCheque;
DBCC CHECKIDENT('[TestDB].[dbo].[PaymentCheque]', RESEED, 0);

DELETE FROM PaymentBankIn;
DBCC CHECKIDENT('[TestDB].[dbo].[PaymentBankIn]', RESEED, 0);

DELETE FROM PaymentDeposit;
DBCC CHECKIDENT('[TestDB].[dbo].[PaymentDeposit]', RESEED, 0);

DELETE FROM PaymentCreditSale;
DBCC CHECKIDENT('[TestDB].[dbo].[PaymentCreditSale]', RESEED, 0);

DELETE FROM Repair;
DBCC CHECKIDENT('[TestDB].[dbo].[Repair]', RESEED, 0);

DELETE FROM RepairLine;
DBCC CHECKIDENT('[TestDB].[dbo].[RepairLine]', RESEED, 0);

DELETE FROM RepairMaterial;
DBCC CHECKIDENT('[TestDB].[dbo].[RepairMaterial]', RESEED, 0);

DELETE FROM Remainder;
DBCC CHECKIDENT('[TestDB].[dbo].[Remainder]', RESEED, 0);

DELETE FROM CashHandover;
DBCC CHECKIDENT('[TestDB].[dbo].[CashHandover]', RESEED, 0);

DELETE FROM ChequeReceive;
DBCC CHECKIDENT('[TestDB].[dbo].[ChequeReceive]', RESEED, 0);

DELETE FROM ExpenseApplication;
DBCC CHECKIDENT('[TestDB].[dbo].[ExpenseApplication]', RESEED, 0);

DELETE FROM ExpenseApplicationLine;
DBCC CHECKIDENT('[TestDB].[dbo].[ExpenseApplicationLine]', RESEED, 0);

DELETE FROM PayoutVoucher;
DBCC CHECKIDENT('[TestDB].[dbo].[PayoutVoucher]', RESEED, 0);

DELETE FROM PayoutVoucherLine;
DBCC CHECKIDENT('[TestDB].[dbo].[PayoutVoucherLine]', RESEED, 0);

DELETE FROM FormSOP;
DBCC CHECKIDENT('[TestDB].[dbo].[FormSOP]', RESEED, 0);

DELETE FROM FormNBK;
DBCC CHECKIDENT('[TestDB].[dbo].[FormNBK]', RESEED, 0);

DELETE FROM FormIBS;
DBCC CHECKIDENT('[TestDB].[dbo].[FormIBS]', RESEED, 0);

DELETE FROM FormIBSLine;
DBCC CHECKIDENT('[TestDB].[dbo].[FormIBSLine]', RESEED, 0);

DELETE FROM [TestDB].[dbo].[Order];
DBCC CHECKIDENT('[TestDB].[dbo].[Order]', RESEED, 0);

DELETE FROM OrderCustomMade;
DBCC CHECKIDENT('[TestDB].[dbo].[OrderCustomMade]', RESEED, 0);

DELETE FROM OrderModifyRepair;
DBCC CHECKIDENT('[TestDB].[dbo].[OrderModifyRepair]', RESEED, 0);

DELETE FROM OrderPreOrder;
DBCC CHECKIDENT('[TestDB].[dbo].[OrderPreOrder]', RESEED, 0);

DELETE FROM OrderReceive;
DBCC CHECKIDENT('[TestDB].[dbo].[OrderReceive]', RESEED, 0);

DELETE FROM OrderReserve;
DBCC CHECKIDENT('[TestDB].[dbo].[OrderReserve]', RESEED, 0);

DELETE FROM OrderDeposit;
DBCC CHECKIDENT('[TestDB].[dbo].[OrderDeposit]', RESEED, 0);

DELETE FROM Attachment;
DBCC CHECKIDENT('[TestDB].[dbo].[Attachment]', RESEED, 0);

DELETE FROM [TestDB].[dbo].[User] DBCC CHECKINDENT('[TestDB].[dbo].[User]', RESEED, 0);

DELETE FROM [TestDB].[dbo].[RepairPayment] DBCC CHECKINDENT('[TestDB].[dbo].[RepairPayment]', RESEED, 0);