Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table name plural vs singular
Message
 
 
To
21/11/2009 18:03:32
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01435978
Message ID:
01436002
Views:
30
Thank you, Bonnie.

>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.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
Previous
Reply
Map
View

Click here to load this message in the networking platform