How to remove interaction_m2m_skill table from scoped app?

bachhav · ‎12-30-2024

I would like to remove interaction_m2m_skill table from scoped app but I am unable to see the delete table option for this table in the studio as this ServiceNow OOB table.

When I tried to delete the entry from application files, below error occurred:
"Insufficient rights to delete table interaction_m2m_skill. User does not have delete access."

I tried with admin & security_admin role but no luck.

Please help me to remove this table from scoped app.

bachhav · ‎01-31-2025

I solved this by using below script -

var choice = new GlideRecord('sys_metadata');
choice.setWorkflow(false);
choice.addEncodedQuery('sys_scope=aaaaaaaa^sys_class_name!=sys_metadata_delete^sys_nameLIKEm2m');
choice.query();
gs.info(choice.getRowCount());
choice.deleteMultiple();
gs.info(choice.getRowCount());

View solution in original post

Ankur Bawiskar · ‎12-31-2024

@bachhav

but why to delete?

Some ACL might be restricting the delete.

There are some OOB tables which even admin or security admin can't delete

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

Runjay Patel · ‎12-31-2024

Hi @bachhav ,

interaction_m2m_skill is system table which can not be deleted, why you wanna delete it? If not in use simply ignore it. It is creating any issue for you.

-------------------------------------------------------------------------

If you found my response helpful, please consider selecting "Accept as Solution" and marking it as "Helpful." This not only supports me but also benefits the community.

Regards
Runjay Patel - ServiceNow Solution Architect
YouTube: https://www.youtube.com/@RunjayP
LinkedIn: https://www.linkedin.com/in/runjay

-------------------------------------------------------------------------

bachhav · ‎01-02-2025

Hi @Ankur Bawiskar, @Runjay Patel,

We haven't added this table to the scoped app, but it is bundled with it. The SNOW certification team requested that the reference be removed from this table.

We are not using it in the app for any purpose hence I want to remove the reference to this table from the scoped app.

Runjay Patel · ‎01-02-2025

Hi @bachhav ,

Are referencing this table in your other table? if yes then you can remove that column. Why you wanna delete that i still didnt get.