Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Table name plural vs singular
Message
De
21/11/2009 18:47:20
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Versions des environnements
SQL Server:
SQL Server 2005
Divers
Thread ID:
01435978
Message ID:
01436004
Vues:
46
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform