2. Introducing SQL : SQL Naming and Statement Rules : Regular and Delimited Identifiers : Case Sensitivity of Identifiers
 
Share this page                  
Case Sensitivity of Identifiers
Case sensitivity for regular and delimited identifiers is specified at the time a database is created. By default, delimited identifiers are not case sensitive. To comply with ANSI/ISO Entry SQL-92, however, delimited identifiers must be case sensitive.
The DBMS Server treats database, user, group, role, cursor, and location names without regard to case. Mixed-case database or location names cannot be created.
To determine the settings for the database to which a session is connected
Use the DBMSINFO function (see page DBMSINFO Function--Return Information About the Current Session), as follows:
SELECT DBMSINFO('DB_NAME_CASE')
and
SELECT DBMSINFO('DB_DELIMITED_CASE')