Delete All URL Rewrites In Magento-1 (Truncate all existed url i magento)

You may wish to delete all URL rewrites from URL Rewrite Management in Magento at some point, especially if you are frequently importing/exporting product and category data.

By using this following SQL Query.

• SET FOREIGN_KEY_CHECKS = 0;
• TRUNCATE TABLE `core_url_rewrite`;
• SET FOREIGN_KEY_CHECKS = 1;