 durand26
|
| Joined: 25 Jan 2012 |
| Total Posts: 1 |
| |
|
Naming conventions (aka Worms! Now can-free!)
Posted: 10 Apr 2012 08:30 PM |
Do you use any particular naming conventions?
There's a lot of internet discussion about whether to
a) Use prefixes (eg tblCustomers). Some say you should, as it makes it easy to spot a table. Others say you shouldn't, just in case you have to replace a table with a view later down the track, and someone starts naming the view tbl___ so they don't need to change code.
b) Use plurals (eg Customers, rather than Customer). Some say you should, as this is how the Microsoft system tables are done. Other say you shouldn't, as having a singular version puts the root table on the top of the list. (Eg, the Customer table will appear before CustomerOrder, but Customers won't.)
What do you fellow Australian DBAs do? |
|
|
 |
|