Welcome to the Treehouse Community
Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community!
Looking to learn something new?
Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.Start your free trial
Javier Alvarado16,060 Points
Are SQL table names always lower case?
Are SQL table names always lower case? I'm assuming they are based on all of the examples given, but I wanted to double check with the community.
You can do your table names any way that you like - lowercase, camelCase, under_scores, etc. However, once you have decided on a convention you should stick with it throughout the entire database. Also, generally companies will already have a convention set in place that you would follow.
not necessary that the table names always be lower case its really up to you
By personal convention, I prefer to set the table and column names in lowercase. It's sensible to use lettercase in names in Linux/Unix operating systems environments.
Oh, you think there has to be a pattern. Even if they confuse us with new combinations that might not seem significant.