1. Acoustic Help Center
  2. Campaign
  3. Data
  4. Relational tables

Relational tables

See more

Delete a relational table

Avatar
Laura F
  • Updated

Deleting relational tables

Deleting a relational table within Acoustic Campaign may cause the browser to hang and might generate the following error.

The following relational table cannot be deleted. TABLENAME (the actual name of your relational table shows here) cannot be deleted. It is referenced in one or more queries, queries within programs, or dynamic content (in an email or asset library).

Resolving the problem

To resolve the issue, you must remove the queries that are associated with the Relational Table within the Acoustic Campaign.

  1. Go to Relational Tables.
  2. Open the relational table
  3. Click Queries and select all.
  4. Delete associated queries.
  5. Delete Relational Table.

If you need to find which items a relational table is associated to, open a support case and a list will be provided.

Note: Relational table queries do not need to be deleted in order for a relational table to be deleted. If you delete a Relational Table, the data cannot be retrieved. The best course of action is to re-import the data if you have it.

Related articles

Comments

2 comments

Sort by Date Votes
  • Avatar
    Joe James

    Hello

    Is there a way of finding which items a relational table is associated to?

    I am trying to delete a relational table and the failure error says that there are mailing items associated.

    How do I find these mailing items?

    Thanks

    Joe

    1
    Comment actions Permalink
  • Avatar
    Jeri Ellis
    • Edited

    Hello Joe,

    I reached out to our Customer Support team and have found that you will have to open a case with the Customer Support team and they can provide a list for you.

    https://help.goacoustic.com/hc/en-us/articles/360045577553-Open-a-support-case-April-1-and-beyond-

     

    Thank you

    Jeri

    1
    Comment actions Permalink

Please sign in to leave a comment.