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:

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

This action will clear out all manually and system created rewrites and recreate only the needed ones (e.g. current products and categories)