I placed an order on my local. now I want to use local DB for live and I want to delete the all test order.
I know there is some table of all these orders are stored. but I don't know the name of those tables.
please provide me the name of all the tables which stores the order information
Best Answer
[Note] : Please take database backup prior to executing these queries.
I went through all tables and came up with following list of tables that should be truncated in order to clear test data:
Truncate order tables
Truncate Customer tables
Truncate Review tables
Truncate Product tables
SET FOREIGN_KEY_CHECKS = 1;