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.