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

Databases SQL Basics Getting Data from a Database Your First SQL Statement

Javier Alvarado
Javier Alvarado
16,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.

6,509 Points

It is not necessary that the table names always be lower case. The first letter of the name can be upper case and the rest can be lower case. Please spend more time understand the concept, i would do this if i were you.

Happy coding!

5 Answers

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.

Andrew Forryan
Andrew Forryan
811 Points

Do SELECT and FROM always need to be in capitals?

4,953 Points

SQL is not Case Sensitive :)

Oh, you think there has to be a pattern. Even if they confuse us with new combinations that might not seem significant.