Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table name plural vs singular
Message
From
21/11/2009 20:38:20
 
 
To
21/11/2009 19:52:10
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01435978
Message ID:
01436008
Views:
38
I had to google verbacular (interesting - try it) then realized it was a typo <g>

Yeah, as I said it really doesn't matter if you are consistent. One of my partners completely sees it as you do.

Plurals are funny in different languages. Weirdest ones I ran across were bahasa (Indonesian) where you just say the word twice - i.e. orang orang = "men" and Thai where there are qualifiers for every noun.

I see dog five bodies. I have banana 10 combs. There are person 100 person.

Not sure what they do naming databases in Thai. I wonder if the Indonesian version of .NET would rename your table CustomerCustomer <bg>

>>> list/collection of clients be called clients
>
>I think it depends on how you say it, Charles.
>One might say the client table - a place where any one client record would reside, just as one might say a guest house, a stamp collection, a bird house or a dessert table (to mix metaphors).
>Someone else might say a table of clients, a collection of stamps, or a table of desserts and that person would probably call the table clients.
>Some verbaculars don't use abstract nouns or collective nouns the way we do in most parts of the US.
>So my wife, whose family spoke German (Schwabish) primarily when she was young says things like " two insurances" when referring to two insurance policies or "two breads" when referring to two loaves of bread.
>She'd call it clients for sure.
>I note that .NET "pluralizes" table names on its own volition in some cases and that drives me batty.


Charles Hankey

Though a good deal is too strange to be believed, nothing is too strange to have happened.
- Thomas Hardy

Half the harm that is done in this world is due to people who want to feel important. They don't mean to do harm-- but the harm does not interest them. Or they do not see it, or they justify it because they are absorbed in the endless struggle to think well of themselves.

-- T. S. Eliot
Democracy is two wolves and a sheep voting on what to have for lunch.
Liberty is a well-armed sheep contesting the vote.
- Ben Franklin

Pardon him, Theodotus. He is a barbarian, and thinks that the customs of his tribe and island are the laws of nature.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform