When Drupal Says Your New Field Name Already Has a Table
Sometimes I run into phantom fields that I had created for a content type that I later destroyed:
There was a problem creating field Artist Name: Table field_data_field_[YOUR FIELD NAME] already exists.
Instead of sighing and choosing another name, you can delete the table in the database, and the corresponding
field_revision_field_[YOUR FIELD NAME]
.