"but when you have DBs with hundreds of tables, this can add up."
Erm...that statement isn't true. The DB will probably work faster with grouped tablenames over ad-hoc names. You are correct....do what you feel confortable with failing that follow best-practice and examples in-house. N -----Original Message----- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: 19 October 2004 15:18 To: CF-Talk Subject: RE: Field Naming > 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 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. As many have stated, database naming conventions often lead to list wars, to each his own is probably the best convention. :-) Mike ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=37 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181838 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