Singular or plural database table names? [duplicate]

Table Naming Dilemma: Singular vs. Plural Names

Is it better to use singular or plural database table names ? Is there an accepted standard ?

I've heard arguments for and against it, what do you guys think ?

Singular, so you can have:

etc.

IMHO, Table names should be plural like Customers.

Class names should be singular like Customer if it maps to a row in Customers table.

I like singular names but appear to be in the minority.

My personal philosophy is that using a plural database table name is redundant, unless you're only planning for the table to contain one row.

I like to use singular names like Agent that have PK names like AgentID.

But that's just me :o)

Related