1

Possible Duplicate:
mysql naming convention

What is the best naming convention for sql tables?

Can we name them in both upper and lower case or camel case?

Which is correct?

Community
  • 1
  • 1
Aliaksei Bulhak
  • 6,078
  • 8
  • 45
  • 75
  • 2
    It's purely a matter of preference and conforming to any local conventions in place where you work. – David M Aug 16 '12 at 13:23
  • 1
    The choice of words that you use for naming your tables is a lot more important than the case of the letters. One widespread convention is to use singular noun forms for your table names (`employee`, `address`, `destination` instead of `employees`, `addresses`, `destinations`). – Sergey Kalinichenko Aug 16 '12 at 13:31

1 Answers1

1

As far as I know, it doesn't matter too much as long as it's the same format for the entire database. Some prefix with 't_', 'tbl' or don't prefix at all

Rodders
  • 2,425
  • 2
  • 20
  • 34