Drupal 7 Orphaned fields, how should they be deleted?
I recommend using drush for this type of thing and let the field crud api do the heavy lifting.
drush eval field_delete_field("YOUR_FIELD_GOES_HERE")