CODE EXAMPLE FOR PHP

truncate url rewrites magento 2 database

DELETE FROM url_rewrite WHERE entity_type='product' AND is_autogenerated='1';