Should SQL table names be capitalized?

Should table name be capitalized?

Only Use Lowercase Letters, Numbers, and Underscores table. column pattern. Queries are harder to write if you use capital letters in table or column names. If everything is lowercase, no one has to remember if the users table is Users or users.

Does capitalization in SQL matter?

The SQL Keywords are case-insensitive ( SELECT , FROM , WHERE , etc), but are often written in all caps. However in some setups table and column names are case-sensitive.

Should database name be capitalized?

Database names (e.g. c9 or imdb ) should be lowercased (no numbers or special characters lie "_" or "-").

What are the rules for naming a SQL table?

The rules for naming database objects (such as tables, columns, views, and database procedures) are as follows: Names can contain only alphanumeric characters and must begin with an alphabetic character or an underscore (_). Database names must begin with an alphabetic character, and cannot begin with an underscore.