skip to main content
Basic elements of SQL : Schema object names and qualifiers
 

Schema object names and qualifiers

Object names and qualifiers are referred to as identifiers. OpenAccess SDK supports names with the following properties:
Schema names can be a maximum length of 128 characters.
Names must begin with an alpha character (a-z, A-Z) and may contain the following characters: a-z, A-Z, 0-9, _, @, #, ^,$, &, ~, %.
Use of the character “\” is not supported as it conflicts with its use by ODBC as an escape characters in SQLTables and other catalog functions.
Names are not case-sensitive.
A name cannot be a reserved word.