Are table names case sensitive?

Is SQL table names case sensitive?

Table names are stored in lowercase on disk and name comparisons are not case-sensitive. MySQL converts all table names to lowercase on storage and lookup. This behavior also applies to database names and table aliases.

Does capitalization matter in SQL table names?

SQL standard requires names stored in uppercase The SQL standard requires identifiers be stored in all-uppercase.

Are table and column names case sensitive in SQL?

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 Oracle table 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.)