I learned singular as well. Maybe it has changed. I do agree with Charles that consistency is the most important thing. Table names of Customer or Customers are both pretty clear.

>I don't know what the consensus is amongst gurus (and, for the record, I am NOT one <g>). Most of the tables in databases that I've worked with have been singular (although there were some plural ones thrown in there too). I'm sure there are others here who have worked with more than just a couple of databases who might have additional opinions on the subject.
>
>~~Bonnie
>
>
>
>>Hi,
>>
>>I have been reading a bunch of articles online of suggested naming conventions for tables. Most - if not all the I found online - suggest defining table names in the plural. I personally don't like it but since most "gurus" advocate plural I was about to use it. But they I saw in my SQL 2005 Unleashed book the author using singular names for tables. So now I have at least one guru on my side <g>. My question is, will my naming of tables - in singular - seem odd to a DBA who will be maintaining my database?
>>
>>TIA.