Tangorre, Michael wrote: >From: Robertson-Ravo, Neil (RX) >> >> Again, its all personal choice. I usually steer well clear >> of underscores as a rule as it can be hard to distinguish >> between multiple underscores.. > > Out of the following, I find option 1 to be the easiest to read. > > APPLICATION_USER > APPLICATION-USER > ApplicationUser > tblApplicationUser
What is wrong with application_user? I prefer to keep everything in lowercase so I can easily distinguish SQL keywords from identifiers. > Prefixing table names with tbl is a waste in my opinion. Say you have 10 > tables all starting with tbl, you have to start at the 4th character to > identify which table you are looking for. Not a major slow down, but > when you have DBs with hundreds of tables, this can add up. I don't think the slow down is really that significant. But what I dislike is that objects in a database are no longer grouped together logically if you prefix them and list them alfabetically. If I have a table with several indexes I want them to appear together when I list all the objects. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Protect your mail server with built in anti-virus protection. It's not only good for you, it's good for everybody. http://www.houseoffusion.com/banners/view.cfm?bannerid=39 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181846 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
