Delete all orders from Magento 2

magento_2_delete_all_orders.sql

-- Delete all orders from Magento 2

SET FOREIGN_KEY_CHECKS=0;

# Clean order history
TRUNCATE TABLE PREFIX_sales_bestsellers_aggregated_daily;
TRUNCATE TABLE PREFIX_sales_bestsellers_aggregated_monthly;
TRUNCATE TABLE PREFIX_sales_bestsellers_aggregated_yearly;

# Clean order infos
TRUNCATE TABLE PREFIX_sales_creditmemo;
TRUNCATE TABLE PREFIX_sales_creditmemo_comment;
TRUNCATE TABLE PREFIX_sales_creditmemo_grid;
TRUNCATE TABLE PREFIX_sales_creditmemo_item;
TRUNCATE TABLE PREFIX_sales_invoice;
TRUNCATE TABLE PREFIX_sales_invoiced_aggregated;
TRUNCATE TABLE PREFIX_sales_invoiced_aggregated_order;
TRUNCATE TABLE PREFIX_sales_invoice_comment;
TRUNCATE TABLE PREFIX_sales_invoice_grid;
TRUNCATE TABLE PREFIX_sales_invoice_item;
TRUNCATE TABLE PREFIX_sales_order;
TRUNCATE TABLE PREFIX_sales_order_address;
TRUNCATE TABLE PREFIX_sales_order_aggregated_created;
TRUNCATE TABLE PREFIX_sales_order_aggregated_updated;
TRUNCATE TABLE PREFIX_sales_order_grid;
TRUNCATE TABLE PREFIX_sales_order_item;
TRUNCATE TABLE PREFIX_sales_order_payment;
TRUNCATE TABLE PREFIX_sales_order_status_history;
TRUNCATE TABLE PREFIX_sales_order_tax;
TRUNCATE TABLE PREFIX_sales_order_tax_item;
TRUNCATE TABLE PREFIX_sales_payment_transaction;
TRUNCATE TABLE PREFIX_sales_refunded_aggregated;
TRUNCATE TABLE PREFIX_sales_refunded_aggregated_order;
TRUNCATE TABLE PREFIX_sales_shipment;
TRUNCATE TABLE PREFIX_sales_shipment_comment;
TRUNCATE TABLE PREFIX_sales_shipment_grid;
TRUNCATE TABLE PREFIX_sales_shipment_item;
TRUNCATE TABLE PREFIX_sales_shipment_track;
TRUNCATE TABLE PREFIX_sales_shipping_aggregated;
TRUNCATE TABLE PREFIX_sales_shipping_aggregated_order;

# Clean cart infos
TRUNCATE TABLE PREFIX_quote;
TRUNCATE TABLE PREFIX_quote_address;
TRUNCATE TABLE PREFIX_quote_address_item;
TRUNCATE TABLE PREFIX_quote_id_mask;
TRUNCATE TABLE PREFIX_quote_item;
TRUNCATE TABLE PREFIX_quote_item_option;
TRUNCATE TABLE PREFIX_quote_payment;
TRUNCATE TABLE PREFIX_quote_shipping_rate;

# Reset indexes (if you want your orders number start back to 1
TRUNCATE TABLE PREFIX_sequence_invoice_1;
TRUNCATE TABLE PREFIX_sequence_order_1;
TRUNCATE TABLE PREFIX_sequence_shipment_1;
TRUNCATE TABLE PREFIX_sequence_creditmemo_1;


SET FOREIGN_KEY_CHECKS=1;