Was this helpful?
Case Sensitivity for Identifiers
The ANSI Entry SQL-92 standard specifies how case is handled for identifiers (names of tables, for example). Identifiers can be quoted or unquoted (regular or delimited (see page Regular and Delimited Identifiers on page 32)).
Regular Identifiers
ANSI/ISO Entry SQL-92
Regular identifiers are treated as upper case:
dbmsinfo('db_name_case') returns UPPER.
Ingres Default
Regular identifiers are treated as lower case:
dbmsinfo('db_name_case') returns LOWER.
Delimited Identifiers
ANSI/ISO Entry SQL-92
Delimited identifiers are case-sensitive:
dbmsinfo('db_delimited_case') returns MIXED.
Ingres Default
Delimited identifiers are not case-sensitive:
dbmsinfo('db_delimited_case') returns LOWER.
User Names
ANSI/ISO Entry SQL-92
User names are treated as upper case:
dbmsinfo('db_real_user_case') returns UPPER.
Ingres Default
User names are treated as lower case:
dbmsinfo('db_real_user_case') returns LOWER.
Last modified date: 01/30/2023