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 |
|
overbored
Starting Member
12 Posts |
 Posted - 2002-07-15 : 19:36:16
|
| Is there some sort of standard (Microsoft-supported?) guideline as to how to name tables and columns in SQL? Mainly this is because I see people adding certain prefixes followed by underscores to their column names, and I'm wondering what they mean/are for. Thanks. |
|
|
JustinBigelow
SQL Gigolo
1157 Posts |
Posted - 2002-07-15 : 20:18:41
|
| There are several different naming schemes in the programming world. Everybody uses what they are comfortable with, what their company standart annotation is, or what your college professor pounded into sleep deprived head. MS doesnt seem to espouse one convention over the other but I do see Hungarian notation in alot of their samples (however that is probably just the author's preference).Justin |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-07-15 : 21:21:31
|
| The best naming convention you can use is:A. descriptiveB. consistentIt really doesn't matter whether or not you use prefixes for tables, columns, views, and so on. As long as you can look at an object name and know what it means, and that column names are consistent, you'll do well. |
|
|
|
|
|
|
Naming Conventions