Magento 2 check "Use Default Value" checkbox for store view
Important: Take a backup of the database before do this.
Run below queries to your database to check the checkbox of "Use Default Value" for all the fields of product.
delete from catalog_product_entity_int where IFNULL(store_id, 0) <> 0;
delete from catalog_product_entity_decimal where IFNULL(store_id, 0) <> 0;
delete from catalog_product_entity_text where IFNULL(store_id, 0) <> 0;
delete from catalog_product_entity_datetime where IFNULL(store_id, 0) <> 0;
delete from catalog_product_entity_varchar where IFNULL(store_id, 0) <> 0;
delete from catalog_product_entity_int where IFNULL(store_id, 0) <> 0;
delete from catalog_product_entity_media_gallery_value where IFNULL(store_id, 0) <> 0;
Run below queries to your database to check the checkbox of "Use Default Value" for all the fields of category.
delete from catalog_category_entity_varchar where IFNULL(store_id, 0) <> 0;
delete from catalog_category_entity_text where IFNULL(store_id, 0) <> 0;
delete from catalog_category_entity_int where IFNULL(store_id, 0) <> 0;
delete from catalog_category_entity_decimal where IFNULL(store_id, 0) <> 0;
delete from catalog_category_entity_datetime where IFNULL(store_id, 0) <> 0;
After running all the above queries you can see the checkbox of all the fields of products and categories have been checked.