The Problem With Bulk Removal of Post Thumbnails or Featured Images
Unfortunately, by default you can only remove featured images by editing each post and removing the featured image. Now if a user has hundreds of posts with featured images, then removing them one by one can be a very time consuming task. Instead, we are going to try a different approach. We will run a database query and unset the featured images on all posts.
Before you proceed, please note that the code below will remove featured images from all posts on your WordPress site by simply just pasting. Also note that this code will not delete any of your uploaded images, they will still be available in Media Library and you can reuse them anytime.
All you need to do is copy and paste this code in your theme’s
Tables can't be imported directly. Please insert an image of your table which can be found here.1 2 3 4 5
That’s all. As soon as you save your functions.php file this script will run a database query and remove featured images from all posts.
Important: Please remove this code immediately after saving your functions.php file. You will not be able to set featured images in WordPress as this code will keep removing featured images from posts.