Delete a Many-to-Many Definition

[aaron_damyen]

I have created a Many-to-Many Definition using the instructions from the wiki (Creating a Many-to-Many Relationship - ServiceNow Wiki).   As usual, the requirements have changed and I no longer need the definition or the table.   As an admin, I cannot find a delete option on the form or list view, so I presume there is purpose for the functionality being hidden.

How do I properly delete a Many-to-Many Definition?

[neetusingh · Accepted solution]

There is an ACL defined for it on delete operation for this M2M (sys_m2m) table, which you need to deactivate before you can delete your M2M definition relationship table... For more, screenshot is attached..

I hope this helps you

[aaron_damyen]

Thanks.   This put me on the right path.

Looking at the Business Rules on the table, creating the actual table is the only associated activity I could find.   After de-activating the ACL, I was able to delete the record on the sys_m2m table.   However, I had to manually delete the table too.

[cfam1]

Thanks neetusingh!   This solved my problem!

[Thrishna Strach]

Help please. I deactivated the ACL. The delete option appears, but then nothing happened. I checked and Can Delete was not checked, so I went ahead and did that. Even so, after that the system still will not allow me to Delete the record. After clicking on Delete nothing happens. No "are you sure you want to delete" box appears. Any ideas as to what I might be missing.

I'm running Helsinki patch 9.   The list is ListV3. If for some reason I'm not able to delete, I would like to be able to edit the data in the m2m from field and m2m to field. Something went wrong when I entered the data and the fields aren't correct.