Answered by : enchanting-echidna-qao966rta628

SET FOREIGN_KEY_CHECKS=0;

Source : https://stackoverflow.com/questions/8538636/does-mysql-foreign-key-checks-affect-the-entire-database | Last Update : Fri, 11 Dec 20

Answered by : filthy-ferret-f4awyp55h5f0

TRUNCATE TABLE `sales_bestsellers_aggregated_daily`;
TRUNCATE TABLE `sales_bestsellers_aggregated_monthly`;
TRUNCATE TABLE `sales_bestsellers_aggregated_yearly`;

Source : https://magento.stackexchange.com/questions/242334/magento-2-how-to-delete-orders-from-the-database | Last Update : Tue, 28 Sep 21

Answered by : filthy-ferret-f4awyp55h5f0

TRUNCATE TABLE `quote`;
TRUNCATE TABLE `quote_address`;
TRUNCATE TABLE `quote_address_item`;
TRUNCATE TABLE `quote_id_mask`;
TRUNCATE TABLE `quote_item`;
TRUNCATE TABLE `quote_item_option`;
TRUNCATE TABLE `quote_payment`;
TRUNCATE TABLE `quote_shipping_rate`;

Source : https://magento.stackexchange.com/questions/242334/magento-2-how-to-delete-orders-from-the-database | Last Update : Tue, 28 Sep 21