Identifier Case

In SQL statements and catalog function arguments, identifiers and quoted identifiers can be either case sensitive or case insensitive. An application determines which they are by calling SQLGetInfo with the SQL_IDENTIFIER_CASE and SQL_QUOTED_IDENTIFIER_CASE options.

Each of these options has four possible return values: one stating that the identifier or quoted identifier case is sensitive and three stating that it is not sensitive. The three not case sensitive values further describe the case in which identifiers are stored in the system catalog. How identifiers are stored in the system catalog is relevant only for display purposes, such as when an application displays the results of a catalog function; it does not change the case sensitivity of identifiers.