Page 1 of 1

Table Name Conventions/Standards

Posted: Fri Oct 24, 2003 6:57 am
by zenabi
This isn't overly important, but is it recommended to have tables named in a singular or plural manner?

Eg.

Code: Select all

SELECT * FROM user
or

Code: Select all

SELECT * FROM users

Posted: Fri Oct 24, 2003 8:04 am
by twigletmac
It's totally up to you, I tend to use plurals for the table name and then singulars for fields but that's just because I like it that way.

Mac

Posted: Fri Oct 24, 2003 8:06 am
by evilMind
It makes more sense to have a table called "users" which will store multiple users (instead of user which makes it seem like there is only one 'user'). Just as it would make more sense to have a table named 'cars' which would hold information about many 'cars' not just one. As mentioned earlier, it's really up to you; however, it makes more sense to stick with what twigletmac posted.