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! While you're at it, check out some resources Treehouse students have shared here.

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
Posted by 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.

aakarshrestha
aakarshrestha
6,509 Points
aakarshrestha
aakarshrestha
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

Shane Robinson
Shane Robinson
7,324 Points

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.

jovani calixte
seal-mask
.a{fill-rule:evenodd;}techdegree
jovani calixte
Android Development Techdegree Student 139 Points
jovani calixte
.a{fill-rule:evenodd;}techdegree
jovani calixte
Android Development Techdegree Student 139 Points

not necessary that the table names always be lower case its really up to you

Juan Miguel Mendez Carrera
Juan Miguel Mendez Carrera
3,953 Points
Juan Miguel Mendez Carrera
Juan Miguel Mendez Carrera
3,953 Points

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
Andrew Forryan
Andrew Forryan
811 Points

Do SELECT and FROM always need to be in capitals?

ROBERTO PINTO
ROBERTO PINTO
4,953 Points
ROBERTO PINTO
ROBERTO PINTO
4,953 Points

SQL is not Case Sensitive :)

Codi Hasbrouck
Codi Hasbrouck
41 Points
Codi Hasbrouck
Codi Hasbrouck
41 Points

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