DB Local/Test cleaning, Removing all orders Q&A

Tips & Tricks
1 
IF NOT OBJECT_ID('dbo.ECommerce_AdditionalOrderInfo') IS NULL EXEC(N'DELETE FROM dbo.ECommerce_AdditionalOrderInfo');
IF NOT OBJECT_ID('dbo.ECommerce_AdditionalDeliveryInfo') IS NULL EXEC(N'DELETE FROM dbo.ECommerce_AdditionalDeliveryInfo');
IF NOT OBJECT_ID('dbo.ECommerce_AdditionalPaymentInfo') IS NULL EXEC(N'DELETE FROM dbo.ECommerce_AdditionalPaymentInfo');
IF NOT OBJECT_ID('dbo.ECommerce_OrderRow') IS NULL EXEC(N'DELETE FROM dbo.ECommerce_OrderRow');
IF NOT OBJECT_ID('dbo.ECommerce_PaymentInfoRow') IS NULL EXEC(N'DELETE FROM dbo.ECommerce_PaymentInfoRow');
IF NOT OBJECT_ID('dbo.ECommerce_Delivery') IS NULL EXEC(N'DELETE FROM dbo.ECommerce_Delivery');
IF NOT OBJECT_ID('dbo.ECommerce_PaymentInfo') IS NULL EXEC(N'DELETE FROM dbo.ECommerce_PaymentInfo');
IF NOT OBJECT_ID('dbo.ECommerce_OrderDiscount') IS NULL EXEC(N'DELETE FROM dbo.ECommerce_OrderDiscount');
IF NOT OBJECT_ID('dbo.ECommerce_Order') IS NULL EXEC(N'DELETE FROM dbo.ECommerce_Order');
IF NOT OBJECT_ID('dbo.ECommerce_CustomerInfo') IS NULL EXEC(N'DELETE FROM dbo.ECommerce_CustomerInfo');
IF NOT OBJECT_ID('dbo.ECommerce_Address') IS NULL EXEC(N'DELETE FROM dbo.ECommerce_Address');
IF NOT OBJECT_ID('dbo.ECommerce_Order') IS NULL EXEC(N'DELETE FROM dbo.ECommerce_Order');
2 Likes
2

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.