> Why would you name tables singular? I can give many reasons > why they should be plural, but that aside, are the existing > SQL Server System tables singular or plural? Plural.
Why would you drive on the right side of the road? I can give many reasons why you should drive on the left side of the road, but that aside, how does one drive in England? On the left side of the road. How you name your database tables is a convention, and as such, doesn't really matter as long as you are consistent in your application of the convention. That said, the justification for naming tables using singular entity names is that the tables represent collections of singular entities. Let's say you have a set of products. You want to describe them within a table, so you name it "product". You can then talk about how you have a many-to-many relationship between "product" and "category", which makes more sense than using the plural in that a single product is what has the relationship to a given category, not the entire set of products. But again, it really doesn't make any difference, as long as you're consistent - there's nothing more annoying than having a database with some tables using singular names and others using plural names. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200617 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
