Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sql777
Constraint Violating Yak Guru
314 Posts |
 Posted - 2003-11-23 : 14:20:34
|
| Hi,What is a good table prefix for relation tables? (tables that hold only the primary keys of 2 different tables).do you guys use: relEmployeeTasks for Employee and Task relations? |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-11-23 : 15:11:06
|
| How about no prefixes at all? What's wrong with EmployeeTasks? And if that's not descriptive enough, how does adding "rel" make it better? I think you'll find it doesn't. |
 |
|
|
sql777
Constraint Violating Yak Guru
314 Posts |
Posted - 2003-11-23 : 15:43:43
|
| Hmm....you do have a point mister. |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2003-11-24 : 01:39:13
|
| Yep, I'd use EmployeeTask. That tells you that its a join table between Employee and Task. Adding rel to the front of that would not really add anything except extra typing!Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
|
|
|
table prefixes