Re: [SQLDownUnder] [SQLStyle] #1: Singular vs Plural Table Naming

[David Spearritt]

> [CONS] Plurals for table names are generally inconsistent. Some end in "s"
> others "ies", others "es" or "ys" etc. So there is a higher likelihood of
> developers misspelling the names.
>
> [CONS] When you have a link table, you don't put the plural in each half of
> the name. CustomerAddresses, not CustomersAddresses, or do you?
I'm with Celko on this. The best name is a singular name that refers
to the set or collection like CustomerAddressBook.

David Spearritt
http://www.orlitech.com.au


to unsubscribe to this list, please send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com - List managed by http://www.readify.net