How can I delete or empty database fields?
Deleting and emptying database fields.
Before you begin
A database field can be deleted after the database has been saved. Database fields can also be renamed and their contents, if needed, emptied.
Run the Field Usage report as follows before making any modifications to the field.
- In Data, go to View Data or Manage.
- Click the name of your database, then, in the Fields tab, click Edit next to the field you would like to change.
- On the following screen(s), click Run Usage, then Submit.
- Click Data Job ID, then Download.
- Evaluate the results. Referenced items may need to be deleted from the Shared/Private directory and deleted tab directory in order to remove the database field. However, if the field is in use, you may not want to delete the field.
About this task
Any changes made to list name could affect existing personalization in emails. Review all emails attached to the modified database and change any personalization associated with the renamed field.
If a recurring import takes place and the field that was deleted in the database is present in the recurring import, that field is added back into the database.
Procedure
What to do next
If you delete a field from your Acoustic Campaign database, but you still see the field, this is because the field is referenced in a recurring Import field mapping file that was created before the field was deleted. Even after the field is deleted, the field is recreated the next time the import job runs.
To resolve this issue, cancel all recurring imports that were created since the field was created. Delete the field, then recreate the recurring imports so that the deleted field is no longer referenced.