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 Regular and Delimited Identifiers on page 36)).
Regular Identifiers
ANSI/ISO Entry SQL-92
Regular identifiers are treated as upper case:
dbmsinfo('db_name_case') returns UPPER.
Actian X 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.
Actian X 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.
Actian X Default
User names are treated as lower case:
dbmsinfo('db_real_user_case') returns LOWER.
Last modified date: 02/03/2024