Should column names be capitalized?

Should column be capitalized?

The column names which are mixed case or uppercase have to be double quoted in PostgreSQL. If you don't want to worry about it in the future, name it in the lower case. MySQL - the columns are absolutely case insensitive.

Does capitalization matter in SQL column names?

At the time of table creation, all columns are created with all lowercase names regardless of quoting. The column names in a select statement are not case sensitive even if quoted.

Are SQL column names case-sensitive?

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.

Are Oracle column names case-sensitive?

By default, Oracle identifiers (table names, column names, etc.) are case-insensitive. You can make them case-sensitive by using quotes around them (eg: SELECT * FROM "My_Table" WHERE "my_field" = 1 ). SQL keywords ( SELECT , WHERE , JOIN , etc.)