Magento Delete All ‘Url Rewrite Management’ URLs in the Database

To delete all the URL rewrites from the Magento admin backend, you can do the following:

• Using your favourite database browser, connect to your Magento database
• Go to the table named ‘core_url_rewrite’
• Empty this table
• Log back in to the Magento backend and reindex all

This action will clear out all manually and the system created rewrites and recreate only the needed ones.