Calvin Ward wrote: >Now you're delving into normalization, which is loosely connected, but not >tightly coupled, with table/view/etc. naming conventions. > > Yeah. Normalisation is something that I do without even thinking about it these days. I didn't really want to get into it, but it related to Will's question of naming tables and using tblDoctor and so on.
>I also don't like to use tbl as a prefix, however using a prefix for link >tables, views, stored procedures, etc. seems fine. > > My use of the tbl prefix comes and goes (consistent within a project). Sometimes I like to use it. Other times it annoys the hell out of me. It is, however, useful for grouping tables, link tables, views, sp, etc together when viewing database objects. Its mildly annoying when you have lnkTableName and a data table vanishes into the midst of the link tables because the table name begins with the letter "L". Even after 16 years of database design and development I still haven't come up with a table naming convention that I'm really happy with. Its probably a bit like how I now like cabbage, when I used to hate it as a kid. My tastes keep changing. Stephen ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200667 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
