Is there any reason why I shouldn't use uppercase letters in my table and column names? I am curious because I am building a web app that I want to make as flexible as possible in relation to OS and RDBMS. i.e.
columnOne, tableTwo, etc...
TIA!
There is no technical reason that I know of. Stylistically, it is sort of traditional to use upper-case letters for SQL functions and reserved words, and use lower-case for table and column names to differentiate them from those SQL words. I always use underscores as word separators for column/table names, I suppose because that's the style that was used on all the projects I've worked on.
I vary. For whatever reason, I started using camel case on my table/column names/methods/etc. in a recent project I started.
In an older project, however, I did all lower-case with underscores as word separators (as NogDog mentions).
Thanks guys. 🙂
