🔦 Feature: Display M2M Tables name near every m2m relationship

[MichaelCereda]

Please confirm if feature request does NOT exist already ?

• [X] I confirm there is no existing issue for this

Describe the usecase for the feature

It's often very useful to create views or routines on other schemas that link directly to tables in Nocodb. It's getting progressively harder to see what is the name of the m2m table that links two other tables.

Suggested Solution

make the m2m table related to a column visible in the dropdown menu of the said column.

or as part of the "Details > Relations" section.

Another alternative would be to allow another checkbox in the relations graph [] Show M2M tables.

I think the cleanest solution would be the latter, but it might be more involved than the other two.

Additional Context

No response

[dstala]

Base settings has an option Show M2M tables

Is this what you are looking for? Why do you wish to access m2m relationship table?

[MichaelCereda]

Yes... that would show the m2m in the list of the tables (Sidebar). But I cnnot see the m2m associated to a specific relationship like I did before.... the many to many above was also showing a m2m prefixed table in the "system fields" before the recent updates. now it's very hard to find which one of the m2m tables is joining Table1 with Table2.

Is there a way to solve that? maybe I can be pointed to an internal table that does the mapping. The current m2m tables also don't use foreign keys so I cannot check the definition to understand what they are pointing to. Thank you