Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table name plural vs singular
Message
From
21/11/2009 18:47:20
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01435978
Message ID:
01436004
Views:
43
>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.

Using plural for table name makes sense because a table is typically a collection of something ( customers, cars, orders ... ). Using singular would seem to be odd to a DBA bt you can do it (VFP samples also have done that too), it would work.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform