What’s the correct name for an “association table” (a many-to-many relationship) [closed]

by

There is no “correct” name, but the academic name would be an “Associative Table” (see See the Wikipedia article Associative Entity). Other common names are (in alphabetical order):

  • Association table
  • Bridge table
  • Cross-reference table
  • Crosswalk
  • Intermediary table
  • Intersection table
  • Join table
  • Junction table
  • Link table
  • Linking table
  • Many-to-many resolver
  • Map table
  • Mapping table
  • Pivot Table
  • Pairing table
  • Relationship table
  • Transition table

Note: This is contents original created by Derek Greer but that was posted as an edit to an accepted answer that totally changed the answer.

More Related Contents:

  1. Stored Procedure with optional “WHERE” parameters
  2. update columns values with column of another table based on condition [duplicate]
  3. How do I list all the columns in a table?
  4. Is there a combination of “LIKE” and “IN” in SQL?
  5. SQL – How to store and navigate hierarchies?
  6. Can a foreign key be NULL and/or duplicate?
  7. Emulate MySQL LIMIT clause in Microsoft SQL Server 2000
  8. Multiplication aggregate operator in SQL
  9. SQL: Repeat a result row multiple times, and number the rows
  10. How do I decide when to use right joins/left joins or inner joins Or how to determine which table is on which side?
  11. MySQL equivalent of DECODE function in Oracle
  12. Deferrable Constraints in SQL Server
  13. Benefits Of Using SQL Ordinal Position Notation?
  14. How do I specify date literal when writing SQL query from SQL Server that is linked to Oracle?
  15. Unordered results in SQL
  16. How do I create a table alias in MySQL
  17. Backup SQL Schema Only?
  18. Connecting to Oracle Database using Sql Server Integration Services
  19. Why in SQL NULL can’t match with NULL?
  20. How to get the byte size of resultset in an SQL query?
  21. Is there an Oracle equivalent to SQL Server’s OUTPUT INSERTED.*?
  22. How to get next/previous record in MySQL?
  23. ORA-12560: TNS:protocol adaptor error
  24. Select statement to find duplicates on certain fields
  25. Getting only Month and Year from SQL DATE
  26. Check for file exists or not in sql server?
  27. How to ORDER BY a SUM() in MySQL?
  28. Merge row values into a CSV (a.k.a GROUP_CONCAT for SQL Server)
  29. What are the max number of allowable parameters per database provider type?
  30. Convert bigint to datetime

Leave a Comment