> 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=36 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181835 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
