HiveBrain v1.2.0
Get Started
← Back to all entries
principleCritical

Plural vs Singular Table Name

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
namesingularpluraltable

Problem

How should I name my Tables when creating a new database?

Singular: Client or Plural: Clients?

Solution

Up to you. Just be consistent though.

Personally I prefer singular based on what each *row" stores: Order, Product, User, Item, etc.

This matches my modelling (via Object Role Modelling) where I use singular entities/types.

Edit:

One reason is that plural fails when you have link tables:

Orders, Products would give OrderProducts or OrdersProducts. Neither sounds correct

Or history tables (of course you can use schemas for this):

Orders -> OrdersHistory or (no!) OrdersHistories? Wouldn't Order-> OrderHistory be better?

Context

StackExchange Database Administrators Q#13730, answer score: 70

Revisions (0)

No revisions yet.