DELETE FROM ShoppingCartItem
DELETE FROM OrderNote
DELETE FROM OrderProductVariant
DELETE FROM RecurringPayment
DELETE FROM RewardPointsHistory
DELETE FROM [Order]
DELETE FROM ProductVariantAttributeCombination
DELETE FROM RelatedProduct
DELETE FROM ProductVariantAttributeValue
DELETE FROM ProductVariant_ProductAttribute_Mapping
DELETE FROM ProductAttribute
DELETE FROM ProductVariant
DELETE FROM Picture
DELETE FROM Product_Category_Mapping
DELETE FROM Product
DELETE FROM Category
DELETE FROM Picture
DBCC CHECKIDENT (ShoppingCartItem, RESEED, 0)
DBCC CHECKIDENT (OrderNote, RESEED, 0)
DBCC CHECKIDENT (OrderProductVariant, RESEED, 0)
DBCC CHECKIDENT (RecurringPayment, RESEED, 0)
DBCC CHECKIDENT (RewardPointsHistory, RESEED, 0)
DBCC CHECKIDENT ([Order], RESEED, 0)
DBCC CHECKIDENT (ProductVariantAttributeCombination, RESEED, 0)
DBCC CHECKIDENT (RelatedProduct, RESEED, 0)
DBCC CHECKIDENT (ProductVariantAttributeValue, RESEED, 0)
DBCC CHECKIDENT (ProductVariant_ProductAttribute_Mapping, RESEED, 0)
DBCC CHECKIDENT (ProductAttribute, RESEED, 0)
DBCC CHECKIDENT (ProductVariant, RESEED, 0)
DBCC CHECKIDENT (Picture, RESEED, 0)
DBCC CHECKIDENT (Product_Category_Mapping, RESEED, 0)
DBCC CHECKIDENT (Product, RESEED, 0)
DBCC CHECKIDENT (Category, RESEED, 0)
DBCC CHECKIDENT (Picture, RESEED, 0)
DELETE FROM ShoppingCartItem
DELETE FROM ReturnRequest
DELETE FROM OrderNote
DELETE FROM OrderItem
DELETE FROM RecurringPaymentHistory
DELETE FROM RewardPointsHistory
DELETE FROM [Order]
DELETE FROM RelatedProduct
DELETE FROM ProductVariantAttributeCombination
DELETE FROM ProductVariantAttributeValue
DELETE FROM Product_ProductAttribute_Mapping
DELETE FROM ProductAttribute
DELETE FROM ProductReviewHelpfulness
DELETE FROM ProductReview
DELETE FROM Product_Picture_Mapping
DELETE FROM Picture
DELETE FROM Product_ProductTag_Mapping
DELETE FROM ProductTag
DELETE FROM Product_Category_Mapping
DELETE FROM Product
DELETE FROM Category
DELETE FROM Manufacturer
DBCC CHECKIDENT (ShoppingCartItem, RESEED, 0)
DBCC CHECKIDENT (ReturnRequest, RESEED, 0)
DBCC CHECKIDENT (OrderNote, RESEED, 0)
DBCC CHECKIDENT (OrderItem, RESEED, 0)
DBCC CHECKIDENT (RecurringPaymentHistory, RESEED, 0)
DBCC CHECKIDENT (RewardPointsHistory, RESEED, 0)
DBCC CHECKIDENT ([Order], RESEED, 0)
DBCC CHECKIDENT (RelatedProduct, RESEED, 0)
DBCC CHECKIDENT (ProductVariantAttributeCombination, 0)
DBCC CHECKIDENT (ProductVariantAttributeValue, RESEED, 0)
DBCC CHECKIDENT (ProductVariant_ProductAttribute_Mapping, RESEED, 0)
DBCC CHECKIDENT (ProductAttribute, RESEED, 0)
DBCC CHECKIDENT (ProductReviewHelpfulness, RESEED, 0)
DBCC CHECKIDENT (ProductReview, RESEED, 0)
DBCC CHECKIDENT (Product_Picture_Mapping, RESEED, 0)
DBCC CHECKIDENT (Picture, RESEED, 0)
DBCC CHECKIDENT (Product_ProductTag_Mapping, RESEED, 0)
DBCC CHECKIDENT (ProductTag, RESEED, 0)
DBCC CHECKIDENT (Product_Category_Mapping, RESEED, 0)
DBCC CHECKIDENT (Product, RESEED, 0)
DBCC CHECKIDENT (Category, RESEED, 0)
DBCC CHECKIDENT (Manufacturer, RESEED, 0)
DELETE FROM ShoppingCartItem
DELETE FROM ReturnRequest
DELETE FROM OrderNote
DELETE FROM OrderItem
DELETE FROM RecurringPaymentHistory
DELETE FROM RewardPointsHistory
DELETE FROM [Order]
DELETE FROM RelatedProduct
DELETE FROM ProductVariantAttributeCombination
DELETE FROM ProductVariantAttributeValue
DELETE FROM Product_ProductAttribute_Mapping
DELETE FROM ProductAttribute
DELETE FROM ProductReviewHelpfulness
DELETE FROM ProductReview
DELETE FROM Product_Picture_Mapping
DELETE FROM Picture
DELETE FROM Product_ProductTag_Mapping
DELETE FROM ProductTag
DELETE FROM Product_Category_Mapping
DELETE FROM Product
DELETE FROM Category
DELETE FROM Manufacturer
DBCC CHECKIDENT (ShoppingCartItem, RESEED, 0)
DBCC CHECKIDENT (ReturnRequest, RESEED, 0)
DBCC CHECKIDENT (OrderNote, RESEED, 0)
DBCC CHECKIDENT (OrderItem, RESEED, 0)
DBCC CHECKIDENT (RecurringPaymentHistory, RESEED, 0)
DBCC CHECKIDENT (RewardPointsHistory, RESEED, 0)
DBCC CHECKIDENT ([Order], RESEED, 0)
DBCC CHECKIDENT (RelatedProduct, RESEED, 0)
DBCC CHECKIDENT (ProductVariantAttributeCombination, 0)
DBCC CHECKIDENT (ProductVariantAttributeValue, RESEED, 0)
DBCC CHECKIDENT (ProductVariant_ProductAttribute_Mapping, RESEED, 0)
DBCC CHECKIDENT (ProductAttribute, RESEED, 0)
DBCC CHECKIDENT (ProductReviewHelpfulness, RESEED, 0)
DBCC CHECKIDENT (ProductReview, RESEED, 0)
DBCC CHECKIDENT (Product_Picture_Mapping, RESEED, 0)
DBCC CHECKIDENT (Picture, RESEED, 0)
DBCC CHECKIDENT (Product_ProductTag_Mapping, RESEED, 0)
DBCC CHECKIDENT (ProductTag, RESEED, 0)
DBCC CHECKIDENT (Product_Category_Mapping, RESEED, 0)
DBCC CHECKIDENT (Product, RESEED, 0)
DBCC CHECKIDENT (Category, RESEED, 0)
DBCC CHECKIDENT (Manufacturer, RESEED, 0)