I received a lot of spam comments in one of my websites running on Drupal 7. I googled for a solution to delete them in bulk and came up on
DELETE FROM comment WERE status = 0
The query worked but the database size did not shrink significantly and I realized out that in addition to the 'comment' table there was another table called
field_data_comment_body
which housed the body of the comment.
I would like to know which all tables are related to comments in Drupal 7
comment_delete()
)