Re: Plural or singular table names

"Ray Cassick (home)" <raycassNOSPAM_at_adelphia.net> wrote in message news:4qf4b.11737$Nc.6608551_at_news1.news.adelphia.net...
> Well my company is going through its processes of writing company
standards
> documents and we are at the age old question:
>
> "Should table names be in the plural or singular forms?"
>
> I figured that I would get a feel here for what the general consensus is
> from the group.
>
> I am from the school that says plural because the table holds multiples of
> one thing. A table that holds employee information should be called
> Employees.
>
> Some of the members of the group here simply think that the table should
not
> be treated as holding a group of employees, but rather it should be
treated
> as simply a place that contains information about THE employee.
>
> If someone can point me to a definitive standard (if one does exist) I
would
> be most grateful. If we are going to go one way or another I want to have
> the decision documented in the appendix of the document so that when
people
> read this years form now there is a clear path of WHY we decided what we
> did.

From a theory standpoint, it's just a name. X and Y are as good as any other names.

I prefer singular because it is just as meaningful as plural and usually shorter. Received on Sun Aug 31 2003 - 07:25:24 CEST