>>Something I think about things that I should not be thinking about (is it called being neurotic <g>?)
>>
>>I am designing a new database and of course new tables. A few sample databases I see (in VFP and in SQL Server) use convention of naming tables as plural (Categories, Companies, Products, etc.) It has always bothered me why they do that.
>>
>>I think that naming tables with singular names makes more sense. Like Category, Company, Product, etc. I see a few benefits of using singular names:
>>1. Fewer letters to type in code.
>>2. When you type COMPANY.ADDRESS it means "one company address", whereas if you type COMPANIES.ADDRESS it is confusing. Am I making sense? <g>.
>>3. Ok, not a few, just two <g>.
>>
>>But there must be reasons why all the database gurus use plural names. What are they?
>
>Dmitry,
>It's mainly a personal preference. To me a table should be plural as it holds information about its singular form :)
>Companies : I know this holds multiple company records.
>If I look a table as a collection of records/objects, collection naming convention is always plural.
>For example I've a table named 'Configuration'. Though it has multiple records all together make a single Configuration for one system and actually all options (records) are shown on the same form at once.
>But again it's a preference :)
>PS: I also find it easier to distinguish say a Customer object from a Customers alias.
>Cetin
I agree with you, it is a personal preference. Thank you for your input.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham