Is there an official name for the many-to-many relationship table in a database schema?

Question

Most of the projects I've worked on have required many-to-many relationships in the database schema. For example, you might have the concept of Users and Groups, and the database might contain a table User, a table Group, and a table UserGroup to relate the two.

I'm interested in the conceptual name of the UserGroup table in that example.

I've grown accustomed to calling them "swing tables" because that's how I learned it, but I haven't heard other people use that term in a while.

Instead, I've heard all of the following (including some new ones, thanks to all of you!):

• Association table
• Bridge table
• Cross-reference table
• Gerund (E.F. Codd, creator of the relational model, may prefer this)
• Intersection tables
• Join table (most search results on Google...see answer below)
• Junction table (Wikipedia favors this one)
• Link table (Fowler likes this one)
• Many-to-many relationship tables
• Map table
• Reference table
• Relationship table
• Swing table

Is there an official name for this kind of table, with a source to back its official-ness?

Answer 1

The most common name is "Join Table" in my opinion, but I have heard several others you have listed. So, I would say "no", there is no "official" name :-)