In my Drupal database I have so many field_deleted_data_XX and field_deleted_revision_XX tables. I have disable the revision entity but I want to delete these existing revision created tables, can I delete these tables directly or Is there any SQL script to delete unused tables from the database.

  • 1
    Just run cron a few times
    – Clive
    Feb 1, 2017 at 13:57

1 Answer 1


You can safely remove them yes. You can use drush to delete these tables: run drush eval 'field_delete_field("yourfield")' and run cron afterwards with drush cron.

  • OK thanks I will try using drush but how to run using cron? can you give some example.
    – kishore ms
    Feb 1, 2017 at 14:10
  • drush cr is a rebuild (drupal_flush_all_caches plus some D8 specific things related to the autoloader), drush cron runs cron.
    – mpdonadio
    Feb 1, 2017 at 14:20
  • Also the run cron option from the system status report page will do it.
    – mradcliffe
    Feb 1, 2017 at 14:32

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.