Lets say you would like to delete all of your Magento RMA.
TRUNCATE TABLE `prefix_enterprise_rma`;
DELETE FROM `prefix_eav_entity_store` WHERE entity_type_id IN ( SELECT `entity_type_id` FROM `prefix_eav_entity_type` WHERE `entity_type_code` = 'rma_item' );There is no need to manually ALTER TABLE 'xyz' AUTO_INCREMENT=1; since TRUNCATE rebuilds the structure of the table and sets AUTO_INCREMENT=1 automatically.
Please note do perform such actions on test deployment and have backups prior of doing such actions!
Delete Magento test orders
Delete all Magento orders
Delete specific Magento RMA