Primary key/foreign Key naming convention [closed]

by

If the two columns have the same name in both tables (convention #2), you can use the USING syntax in SQL to save some typing and some boilerplate noise:

SELECT name, address, amount
  FROM employees JOIN payroll USING (employee_id)

Another argument in favor of convention #2 is that it’s the way the relational model was designed.

The significance of each column is
partially conveyed by labeling it with
the name of the corresponding domain.

More Related Contents:

  1. how to create this table in sql server?
  2. Recommended SQL database design for tags or tagging [closed]
  3. Table Naming Dilemma: Singular vs. Plural Names [closed]
  4. How to create multiple one to one’s
  5. SQL – How to store and navigate hierarchies?
  6. Strings as Primary Keys in SQL Database [closed]
  7. Custom SERIAL / autoincrement per group of values
  8. Safely rename tables using serial primary key columns
  9. A beginner’s guide to SQL database design [closed]
  10. What mysql database tables and relationships would support a Q&A survey with conditional questions? [closed]
  11. Physical vs. logical (hard vs. soft) delete of database record? [closed]
  12. single fixed table with multiple columns vs flexible abstract tables
  13. Is there ever a time where using a database 1:1 relationship makes sense?
  14. DB design to use sub-type or not?
  15. How to design a database for User Defined Fields?
  16. Dynamic Database Schema [closed]
  17. Should I design a table with a primary key of varchar or int?
  18. Composite Primary key vs additional “ID” column?
  19. Relational database design question – Surrogate-key or Natural-key?
  20. Database EAV Pros/Cons and Alternatives
  21. When to Denormalize a Database Design
  22. Naming of ID columns in database tables
  23. Best way to model Customer Address
  24. Should I use SQL_Variant data type?
  25. MySQL – how to front pad zip code with “0”?
  26. PostgreSQL Index on JSON
  27. SQL: Using NULL values vs. default values
  28. What does ON [PRIMARY] mean?
  29. Relational Data Model for Double-Entry Accounting
  30. can we have a foreign key which is not a primary key in any other table?

Leave a Comment