Truncate all customers and their reviews from Magento 2

truncate_customers_magento_2.sql

SET FOREIGN_KEY_CHECKS = 0;

-- TRUNCATE CUSTOMERS
TRUNCATE TABLE `PREFIX_customer_address_entity`;
TRUNCATE TABLE `PREFIX_customer_address_entity_datetime`;
TRUNCATE TABLE `PREFIX_customer_address_entity_decimal`;
TRUNCATE TABLE `PREFIX_customer_address_entity_int`;
TRUNCATE TABLE `PREFIX_customer_address_entity_text`;
TRUNCATE TABLE `PREFIX_customer_address_entity_varchar`;
TRUNCATE TABLE `PREFIX_customer_entity`;
TRUNCATE TABLE `PREFIX_customer_entity_datetime`;
TRUNCATE TABLE `PREFIX_customer_entity_decimal`;
TRUNCATE TABLE `PREFIX_customer_entity_int`;
TRUNCATE TABLE `PREFIX_customer_entity_text`;
TRUNCATE TABLE `PREFIX_customer_entity_varchar`;
TRUNCATE TABLE `PREFIX_customer_grid_flat`;
TRUNCATE TABLE `PREFIX_customer_log`;
TRUNCATE TABLE `PREFIX_customer_log`;
TRUNCATE TABLE `PREFIX_customer_visitor`;
TRUNCATE TABLE `PREFIX_persistent_session`;
TRUNCATE TABLE `PREFIX_wishlist`;
TRUNCATE TABLE `PREFIX_wishlist_item`;
TRUNCATE TABLE `PREFIX_wishlist_item_option`;


-- TRUNCATE REVIEWS
TRUNCATE TABLE `PREFIX_review`;
TRUNCATE TABLE `PREFIX_review_detail`;
TRUNCATE TABLE `PREFIX_review_entity_summary`;
TRUNCATE TABLE `PREFIX_review_store`;


SET FOREIGN_KEY_CHECKS = 1;