How to create new M@M table in ServiceNow without license

[Rajeev00002]

We have an M2M table that is not part of the exempted table (ua_exempted_table_inventory), and I can see it is listed under ua_custom_table_inventory. That means it needs a license. However, as per our requirements, I should delete the old M2M table and create a new one that should not require a license; it should be part of the Exempted Table inventory. Please help me with how to create that

[Daniel Borkowi1]

Hi @Rajeev00002 , this m2m table must be registered in the m2m_table field in the sys_m2m table. Keep in mind that these tables are restricted to three (3) custom fields in addition to the standard fields created by the system.

Greets
Daniel

Please mark reply as Helpful/Correct, if applicable. Thanks!

[Rajeev00002]

Thank you , but when i create m2m table under sys_m2m, the table is creating with 2 fields and it is part of

ua_custom_table_inventory, but i don't want it to be created as custom table , how can we achieve this ?

[Andreas Borell]

The instructions for how to make an m2m table are here. If following this does not achieve the result you are looking for, you should probably contact your Servicenow representative for a more in depth review of your particular situation.

https://docs.servicenow.com/csh?topicname=t_CreateAManyToManyRelationship.html&version=latest

[Daniel Borkowi1]

Hi @Rajeev00002, no you don't derive from sys_m2m. You only register you custom m2m table in as a record in sys_m2m. 

Open sys_m2m.list via navigator.

Afterwards the table u_m2m_my_custom_table is visible in sys_db_object, there you can add 2 additional fields.

Greets
Daniel

Please mark reply as Helpful/Correct, if applicable. Thanks!