How to delete orders after setting up store
- 1
- 2
- 54
- 338
- 9/10/2014
- New Zealand
Needs one more table deleted
TRUNCATE TABLE OrderNote
DELETE FROM GiftCard
DELETE FROM OrderItem
DELETE FROM RewardPointsHistory
DELETE FROM [Order]
DBCC CHECKIDENT (OrderNote, RESEED, 0)
DBCC CHECKIDENT (GiftCard, RESEED, 0)
DBCC CHECKIDENT (RewardPointsHistory, RESEED, 0)
DBCC CHECKIDENT (OrderItem, RESEED, 0)
DBCC CHECKIDENT ([Order], RESEED, 0)
TRUNCATE TABLE OrderNote
DELETE FROM GiftCard
DELETE FROM OrderItem
DELETE FROM RewardPointsHistory
DELETE FROM [Order]
DBCC CHECKIDENT (OrderNote, RESEED, 0)
DBCC CHECKIDENT (GiftCard, RESEED, 0)
DBCC CHECKIDENT (RewardPointsHistory, RESEED, 0)
DBCC CHECKIDENT (OrderItem, RESEED, 0)
DBCC CHECKIDENT ([Order], RESEED, 0)
- 5
- 35
- 2/10/2022
- Netherlands
Note: I was trying to do the same thing with a MySQL Database. You can run the following:
SET FOREIGN_KEY_CHECKS=0;
TRUNCATE TABLE `OrderNote`;
TRUNCATE TABLE `GiftCard`;
TRUNCATE TABLE `giftcardusagehistory`;
TRUNCATE TABLE `OrderItem`;
TRUNCATE TABLE `order`;
TRUNCATE TABLE `RewardPointsHistory`;
SET FOREIGN_KEY_CHECKS=1;
- 1
- 2