Posted by Greg D. Moore \(Strider\) on 05/04/07 01:39

"--CELKO--" <jcelko212@earthlink.net> wrote in message
news:1178216894.234223.230260@o5g2000hsb.googlegroups.com...
>>> I was taught in school that entity names (tables) should always be in
>>> the singular. <<
>
> That was an old DoD standard that started with file names based on the
> idea that you read one record at a time, so your unit of work world be
> one Order. The conventional wisdom now is that since a table is a
> set, you use a collective name when possible or a plural name if you
> have to (Personnel, not Employees; Forest, not Trees, etc.)
>
>>> Object prefixes like tbl are okay.<<
>
> No they are not. At best they are a redundancy that screws up the
> Data Dictionary. They violate the rule about naming things for their
> nature instead of their implementation or usage. And since SQL is
> a strongly typed language, they look really silly. Do you put
> "noun_" in front of all your nouns to make your sentences easier to
> read?

Joe must be behind the movement I understand in German now to stop
capitalizing nouns. ;-)


>
> As the ISO-11179 rules get into more meta data repository
> requirements, this is going to be important.
>

--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

[Back to original message]