Best practices for First letter capitalization?

Question

I have seen some resources capitalize the first letter of tables and keep the column names in all lowercase. Here, the tables are all lowercase and the the first letter of the column name is capitalized. What are the best practices?

Answer 1

I don't believe there is a best practice for sql table/column name standardisation. You could use any as long as it is consistent.

If you are working with a team, use what they use. If working by yourself use one style and stick to it.

I personally prefer camel-case for columns names and caps for table names. But that's just me.

Answer 2

There are various naming conventions when it comes to SQL databases! I suggest you look at each one and see which works best, this is one example:

https://www.codeproject.com/Articles/1065295/SQL-Server-Table-and-Column-Naming-Conventions

Answer 3

Thank you all for your insights!