SQLGetInfo (ODBC)

The table shows the values returned by SQLGetInfo (may vary based on the version number of the connected server).

fInfoType rgbInfoValue
SQL_ACCESSIBLE_PROCEDURES “Y”
SQL_ACCESSIBLE_TABLES “Y”
SQL_ACTIVE_CONNECTIONS The number of connections is limited by the Microsoft® SQL Server™. The driver returns 0 for this SQLGetInfo request.
SQL_ACTIVE_ENVIRONMENTS The number of environments is not limited by the driver. The driver returns 0 for this SQLGetInfo request.
SQL_ACTIVE_STATEMENTS The driver returns 1 for this SQLGetInfo request. The number of statement handles available to an application is not limited by the driver, but default execution on a statement handle will block execution on any other handle.
SQL_ALTER_DOMAIN FALSE
SQL_ALTER_TABLE SQL_AT_ADD_COLUMN
SQL_AT_ADD_COLUMN_DEFAULT
SQL_AT_ADD_COLUMN_SINGLE
SQL_AT_ADD_CONSTRAINT
SQL_AT_ADD_TABLE_CONSTRAINT
SQL_AT_CONSTRAINT_NAME_DEFINITION
SQL_AT_DROP_COLUMN_RESTRICT
SQL_SQL_CONFORMANCE SQL_SC_SQL92_ENTRY
SQL_DATETIME_LITERALS FALSE
SQL_ASYNC_MODE SQL_AM_STATEMENT
SQL_BATCH_ROW_COUNT SQL_BRC_EXPLICIT
SQL_BATCH_SUPPORT SQL_BS_ROW_COUNT_EXPLICIT
SQL_BS_ROW_COUNT_PROC
SQL_BS_SELECT_EXPLICIT
SQL_BS_SELECT_PROC
SQL_BOOKMARK_PERSISTENCE SQL_BP_DELETE
SQL_BP_SCROLL
SQL_BP_UPDATE
SQL_CATALOG_LOCATION SQL_CL_START
SQL_CATALOG_NAME “Y”
SQL_CATALOG_NAME_SEPARATOR “.”
SQL_CATALOG_TERM “database”
SQL_CATALOG_USAGE SQL_CU_DML_STATEMENTS
SQL_CU_PROCEDURE_INVOCATION
SQL_CU_TABLE_DEFINITION
SQL_COLLATION_SEQ The currently assigned collation sequence for the connection and server.
SQL_COLUMN_ALIAS “Y”
SQL_CONCAT_NULL_BEHAVIOR SQL_CB_NULL
SQL_CB_NON_NULL if connected to a version 6.5 or earlier server, or if AnsiNPW is off when connected to SQL Server 7.0.
SQL_CONVERT_BIGINT No support for conversion of the ODBC SQL_BIGINT data type. The SQL Server ODBC driver supports the SQL Server decimal(19,0) data type as ODBC type SQL_DECIMAL. See SQL_CONVERT_DECIMAL below.
SQL_CONVERT_BINARY SQL_CVT_CHAR
SQL_CVT_NUMERIC
SQL_CVT_DECIMAL
SQL_CVT_INTEGER
SQL_CVT_SMALLINT
SQL_CVT_VARCHAR
SQL_CVT_BINARY
SQL_CVT_VARBINARY
SQL_CVT_TINYINT
SQL_CVT_LONGVARBINARY
SQL_CVT_WCHAR
SQL_CVT_WVARCHAR
SQL_CONVERT_BIT SQL_CVT_CHAR
SQL_CVT_NUMERIC
SQL_CVT_DECIMAL
SQL_CVT_INTEGER
SQL_CVT_SMALLINT
SQL_CVT_FLOAT
SQL_CVT_REAL
SQL_CVT_VARCHAR
SQL_CVT_BINARY
SQL_CVT_VARBINARY
SQL_CVT_BIT
SQL_CVT_TINYINT
SQL_CVT_WCHAR
SQL_CVT_WVARCHAR
SQL_CONVERT_CHAR SQL_CVT_CHAR
SQL_CVT_NUMERIC
SQL_CVT_DECIMAL
SQL_CVT_INTEGER
SQL_CVT_SMALLINT
SQL_CVT_FLOAT
SQL_CVT_REAL
SQL_CVT_VARCHAR
SQL_CVT_LONGVARCHAR
SQL_CVT_BINARY
SQL_CVT_VARBINARY
SQL_CVT_BIT
SQL_CVT_TINYINT
SQL_CVT_TIMESTAMP
SQL_CVT_LONGVARBINARY
SQL_CVT_WCHAR
SQL_CVT_WLONGVARCHAR
SQL_CVT_WVARCHAR
SQL_CONVERT_DATE No support for conversion of the ODBC SQL_TYPE_DATE data type. The SQL Server ODBC driver supports the SQL Server datetime data type as ODBC type SQL_TYPE_TIMESTAMP. See SQL_CONVERT_TIMESTAMP below.
SQL_CONVERT_DECIMAL SQL_CVT_CHAR
SQL_CVT_NUMERIC
SQL_CVT_DECIMAL
SQL_CVT_INTEGER
SQL_CVT_SMALLINT
SQL_CVT_FLOAT
SQL_CVT_REAL
SQL_CVT_VARCHAR
SQL_CVT_BINARY
SQL_CVT_VARBINARY
SQL_CVT_BIT
SQL_CVT_TINYINT
SQL_CVT_WCHAR
SQL_CVT_WVARCHAR
SQL_CONVERT_DOUBLE No support for conversion of ODBC SQL_DOUBLE data type. The SQL Server ODBC driver supports the ODBC SQL_DOUBLE data type as SQL_FLOAT. See SQL_CONVERT_FLOAT below.
SQL_CONVERT_FLOAT SQL_CVT_CHAR
SQL_CVT_NUMERIC
SQL_CVT_DECIMAL
SQL_CVT_INTEGER
SQL_CVT_SMALLINT
SQL_CVT_FLOAT
SQL_CVT_REAL
SQL_CVT_VARCHAR
SQL_CVT_BIT
SQL_CVT_TINYINT
SQL_CVT_WCHAR
SQL_CVT_WVARCHAR
SQL_CONVERT_FUNCTIONS SQL_FN_CVT_CONVERT
SQL_FN_CVT_CAST
SQL_CONVERT_INTEGER SQL_CVT_CHAR
SQL_CVT_NUMERIC
SQL_CVT_DECIMAL
SQL_CVT_INTEGER
SQL_CVT_SMALLINT
SQL_CVT_FLOAT
SQL_CVT_REAL
SQL_CVT_VARCHAR
SQL_CVT_BINARY
SQL_CVT_VARBINARY
SQL_CVT_BIT
SQL_CVT_TINYINT
SQL_CVT_WCHAR
SQL_CVT_WVARCHAR
SQL_CONVERT_INTERVAL_YEAR_MONTH No support for conversion of interval data types.
SQL_CONVERT_INTERVAL_DAY_TIME No support for conversion of interval data types.
SQL_CONVERT_LONGVARBINARY SQL_CVT_BINARY
SQL_CVT_LONGVARBINARY
SQL_CVT_VARBINARY
SQL_CONVERT_LONGVARCHAR SQL_CVT_CHAR
SQL_CVT_VARCHAR
SQL_CVT_LONGVARCHAR
SQL_CVT_WCHAR
SQL_CVT_WLONGVARCHAR
SQL_CVT_WVARCHAR
SQL_CONVERT_NUMERIC SQL_CVT_CHAR
SQL_CVT_NUMERIC
SQL_CVT_DECIMAL
SQL_CVT_INTEGER
SQL_CVT_SMALLINT
SQL_CVT_FLOAT
SQL_CVT_REAL
SQL_CVT_VARCHAR
SQL_CVT_BINARY
SQL_CVT_VARBINARY
SQL_CVT_BIT
SQL_CVT_TINYINT
SQL_CVT_WCHAR
SQL_CVT_WVARCHAR
SQL_CONVERT_REAL SQL_CVT_CHAR
SQL_CVT_NUMERIC
SQL_CVT_DECIMAL
SQL_CVT_INTEGER
SQL_CVT_SMALLINT
SQL_CVT_FLOAT
SQL_CVT_REAL
SQL_CVT_VARCHAR
SQL_CVT_BIT
SQL_CVT_TINYINT
SQL_CVT_WCHAR
SQL_CVT_WVARCHAR
SQL_CONVERT_SMALLINT SQL_CVT_CHAR
SQL_CVT_NUMERIC
SQL_CVT_DECIMAL
SQL_CVT_INTEGER
SQL_CVT_SMALLINT
SQL_CVT_FLOAT
SQL_CVT_REAL
SQL_CVT_VARCHAR
SQL_CVT_BINARY
SQL_CVT_VARBINARY
SQL_CVT_BIT
SQL_CVT_TINYINT
SQL_CVT_WCHAR
SQL_CVT_WVARCHAR
SQL_CONVERT_TIME No support for conversion of the ODBC SQL_TYPE_TIME data type. The SQL Server ODBC driver supports the SQL Server datetime data type as ODBC type SQL_TYPE_TIMESTAMP. See SQL_CONVERT_TIMESTAMP below.
SQL_CONVERT_TIMESTAMP SQL_CVT_CHAR
SQL_CVT_VARCHAR
SQL_CVT_BINARY
SQL_CVT_VARBINARY
SQL_CVT_TIMESTAMP
SQL_CVT_WCHAR
SQL_CVT_WVARCHAR
SQL_CONVERT_TINYINT SQL_CVT_CHAR
SQL_CVT_NUMERIC
SQL_CVT_DECIMAL
SQL_CVT_INTEGER
SQL_CVT_SMALLINT
SQL_CVT_FLOAT
SQL_CVT_REAL
SQL_CVT_VARCHAR
SQL_CVT_BINARY
SQL_CVT_VARBINARY
SQL_CVT_BIT
SQL_CVT_TINYINT
SQL_CVT_WCHAR
SQL_CVT_WVARCHAR
SQL_CONVERT_VARBINARY SQL_CVT_CHAR
SQL_CVT_NUMERIC
SQL_CVT_DECIMAL
SQL_CVT_INTEGER
SQL_CVT_SMALLINT
SQL_CVT_VARCHAR
SQL_CVT_BINARY
SQL_CVT_VARBINARY
SQL_CVT_TINYINT
SQL_CVT_LONGVARBINARY
SQL_CVT_WCHAR
SQL_CVT_WVARCHAR
SQL_CONVERT_VARCHAR SQL_CVT_CHAR
SQL_CVT_NUMERIC
SQL_CVT_DECIMAL
SQL_CVT_INTEGER
SQL_CVT_SMALLINT
SQL_CVT_FLOAT
SQL_CVT_REAL
SQL_CVT_VARCHAR
SQL_CVT_LONGVARCHAR
SQL_CVT_BINARY
SQL_CVT_VARBINARY
SQL_CVT_BIT
SQL_CVT_TINYINT
SQL_CVT_TIMESTAMP
SQL_CVT_LONGVARBINARY
SQL_CVT_WCHAR
SQL_CVT_WLONGVARCHAR
SQL_CVT_WVARCHAR
SQL_CONVERT_WCHAR SQL_CVT_CHAR
SQL_CVT_NUMERIC
SQL_CVT_DECIMAL
SQL_CVT_INTEGER
SQL_CVT_SMALLINT
SQL_CVT_FLOAT
SQL_CVT_REAL
SQL_CVT_VARCHAR
SQL_CVT_LONGVARCHAR
SQL_CVT_BINARY
SQL_CVT_VARBINARY
SQL_CVT_BIT
SQL_CVT_TINYINT
SQL_CVT_TIMESTAMP
SQL_CVT_LONGVARBINARY
SQL_CVT_WCHAR
SQL_CVT_WLONGVARCHAR
SQL_CVT_WVARCHAR
SQL_CONVERT_WLONGVARCHAR SQL_CVT_CHAR
SQL_CVT_VARCHAR
SQL_CVT_LONGVARCHAR
SQL_CVT_WCHAR
SQL_CVT_WLONGVARCHAR
SQL_CVT_WVARCHAR
SQL_CONVERT_WVARCHAR SQL_CVT_CHAR
SQL_CVT_NUMERIC
SQL_CVT_DECIMAL
SQL_CVT_INTEGER
SQL_CVT_SMALLINT
SQL_CVT_FLOAT
SQL_CVT_REAL
SQL_CVT_VARCHAR
SQL_CVT_LONGVARCHAR
SQL_CVT_BINARY
SQL_CVT_VARBINARY
SQL_CVT_BIT
SQL_CVT_TINYINT
SQL_CVT_TIMESTAMP
SQL_CVT_LONGVARBINARY
SQL_CVT_WCHAR
SQL_CVT_WLONGVARCHAR
SQL_CVT_WVARCHAR
SQL_CORRELATION_NAME SQL_CN_ANY
SQL_CREATE_ASSERTION FALSE
SQL_CREATE_CHARACTER_SET FALSE
SQL_CREATE_COLLATION FALSE
SQL_CREATE_DOMAIN FALSE
SQL_CREATE_SCHEMA SQL_CS_AUTHORIZATION
SQL_CS_CREATE_SCHEMA
SQL_CREATE_TABLE SQL_CT_CREATE_TABLE
SQL_CREATE_TRANSLATION FALSE
SQL_CREATE_VIEW SQL_CV_CHECK_OPTION
SQL_CV_CREATE_VIEW
SQL_CURSOR_COMMIT_BEHAVIOR SQL_CB_CLOSE
SQL_CURSOR_ROLLBACK_BEHAVIOR SQL_CB_CLOSE
SQL_CURSOR_SENSITIVITY SQL_SENSITIVE
SQL_DATA_SOURCE_NAME Current data source name. Sets value pointed to by StringLengthPtr to 0 if connection did not specify a data source name.
SQL_DATA_SOURCE_READ_ONLY Depends on setting of connection attribute SQL_ATTR_ACCESS_MODE.
SQL_DATABASE_NAME The connection’s current database.
SQL_DBMS_NAME “Microsoft SQL Server”
SQL_DBMS_VER The version number of the connected SQL Server.
SQL_DEFAULT_TXN_ISOLATION SQL_TXN_READ_COMMITTED
SQL_DESCRIBE_PARAMETER “Y”
SQL_DRIVER_NAME “Sqlsrv32.dll”
SQL_DRIVER_ODBC_VER The driver’s supported ODBC version.
SQL_DRIVER_VER The version number of the driver.
SQL_DROP_ASSERTION FALSE
SQL_DROP_CHARACTER_SET FALSE
SQL_DROP_COLLATION FALSE
SQL_DROP_DOMAIN FALSE
SQL_DROP_SCHEMA DROP SCHEMA not supported.
SQL_DROP_TABLE SQL_DT_DROP_TABLE
SQL_DROP_TRANSLATION FALSE
SQL_DROP_VIEW SQL_DV_DROP_VIEW
SQL_DYNAMIC_CURSOR_ATTRIBUTES1 SQL_CA1_ABSOLUTE
SQL_CA1_BULK_ADD
SQL_CA1_LOCK_NO_CHANGE
SQL_CA1_NEXT
SQL_CA1_POS_DELETE
SQL_CA1_POS_POSITION
SQL_CA1_POS_REFRESH
SQL_CA1_POS_UPDATE
SQL_CA1_POSITIONED_UPDATE
SQL_CA1_POSITIONED_DELETE
SQL_CA1_RELATIVE
SQL_CA1_SELECT_FOR_UPDATE
SQL_DYNAMIC_CURSOR_ATTRIBUTES2 SQL_CA2_LOCK_CONCURRENCY
SQL_CA2_MAX_ROWS_CATALOG
SQL_CA2_MAX_ROWS_DELETE
SQL_CA2_MAX_ROWS_INSERT
SQL_CA2_MAX_ROWS_SELECT
SQL_CA2_MAX_ROWS_UPDATE
SQL_CA2_OPT_ROWVER_CONCURRENCY
SQL_CA2_OPT_VALUES_CONCURRENCY
SQL_CA2_READ_ONLY_CONCURRENCY
SQL_CA2_SENSITIVITY_ADDITIONS
SQL_CA2_SENSITIVITY_UPDATES
SQL_CA2_SIMULATE_UNIQUE
SQL_EXPRESSIONS_IN_ORDERBY “Y”
SQL_FETCH_DIRECTION SQL_FD_FETCH_ABSOLUTE
SQL_FD_FETCH_BOOKMARK
SQL_FD_FETCH_FIRST
SQL_FD_FETCH_LAST
SQL_FD_FETCH_NEXT
SQL_FD_FETCH_PRIOR
SQL_FD_FETCH_RELATIVE
SQL_FILE_USAGE SQL_FILE_NOT_SUPPORTED
SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES1 SQL_CA1_NEXT
SQL_CA1_POSITIONED_DELETE
SQL_CA1_POSITIONED_UPDATE
SQL_CA1_SELECT_FOR_UPDATE
SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES2 SQL_CA2_LOCK_CONCURRENCY
SQL_CA2_MAX_ROWS_CATALOG
SQL_CA2_MAX_ROWS_DELETE
SQL_CA2_MAX_ROWS_INSERT
SQL_CA2_MAX_ROWS_SELECT
SQL_CA2_MAX_ROWS_UPDATE
SQL_CA2_OPT_ROWVER_CONCURRENCY
SQL_CA2_OPT_VALUES_CONCURRENCY
SQL_CA2_READ_ONLY_CONCURRENCY
SQL_GETDATA_EXTENSIONS SQL_GD_BLOCK
SQL_GROUP_BY SQL_GB_GROUP_BY_CONTAINS_SELECT
SQL_IDENTIFIER_CASE SQL_IC_MIXED if connected to a server running a case-insenstive sort order.

SQL_IC_SENSITIVE if connected to a server running case-sensitive sort order.

SQL_IDENTIFIER_QUOTE_CHAR " (the double quote character)
SQL_INDEX_KEYWORDS SQL_IK_ASC
SQL_IK_DESC
SQL_INFO_SCHEMA_VIEWS Request not supported by driver.
SQL_INFO_SS_NETLIB_NAME SQL Server ODBC driver-specific attribute. The name of the network library in use by the connection.
SQL_INTEGRITY “Y”
SQL_KEYSET_CURSOR_ATTRIBUTES1 SQL_CA1_ABSOLUTE
SQL_CA1_BOOKMARK
SQL_CA1_BULK_ADD
SQL_CA1_BULK_DELETE_BY_BOOKMARK
SQL_CA1_BULK_FETCH_BY_BOOKMARK
SQL_CA1_BULK_UPDATE_BY_BOOKMARK
SQL_CA1_LOCK_NO_CHANGE
SQL_CA1_NEXT
SQL_CA1_POS_DELETE
SQL_CA1_POS_POSITION
SQL_CA1_POS_REFRESH
SQL_CA1_POS_UPDATE
SQL_CA1_POSITIONED_DELETE
SQL_CA1_POSITIONED_UPDATE
SQL_CA1_RELATIVE
SQL_CA1_SELECT_FOR_UPDATE
SQL_KEYSET_CURSOR_ATTRIBUTES2 SQL_CA2_CRC_EXACT
SQL_CA2_LOCK_CONCURRENCY
SQL_CA2_MAX_ROWS_CATALOG
SQL_CA2_MAX_ROWS_DELETE
SQL_CA2_MAX_ROWS_INSERT
SQL_CA2_MAX_ROWS_SELECT
SQL_CA2_MAX_ROWS_UPDATE
SQL_CA2_OPT_ROWVER_CONCURRENCY
SQL_CA2_OPT_VALUES_CONCURRENCY
SQL_CA2_READ_ONLY_CONCURRENCY
SQL_CA2_SENSITIVITY_ADDITIONS
SQL_CA2_SENSITIVITY_UPDATES
SQL_CA2_SIMULATE_UNIQUE
SQL_KEYWORDS BREAK
BROWSE
BULK
CHECKPOINT
CLUSTERED
COMMITTED
COMPUTE
CONFIRM
CONTROLROW
DATABASE
DBCC
DISK
DISTRIBUTED
DUMMY
DUMP
ERRLVL
ERROREXIT
EXIT
FILE
FILLFACTOR
FLOPPY
HOLDLOCK
IDENTITY_INSERT
IDENTITYCOL
IF
KILL
LINENO
LOAD
MIRROREXIT
NONCLUSTERED
OFF
OFFSETS
ONCE
OVER
PERCENT
PERM
PERMANENT
PLAN
PRINT
PROC
PROCESSEXIT
RAISERROR
READ
READTEXT
RECONFIGURE
REPEATABLE
RETURN
ROWCOUNT
RULE
SAVE
SERIALIZABLE
SETUSER
SHUTDOWN
STATISTICS
TAPE
TEMP
TEXTSIZE
TRAN
TRIGGER
TRUNCATE
TSEQUEL
UNCOMMITTED
UPDATETEXT
USE
WAITFOR
WHILE
WRITETEXT
SQL_LIKE_ESCAPE_CLAUSE “Y”
SQL_LOCK_TYPES SQL_LCK_NO_CHANGE
SQL_MAX_ASYNC_CONCURRENT_STATEMENTS 1
SQL_MAX_BINARY_LITERAL_LEN 131072
SQL_MAX_CATALOG_NAME_LEN 128/30*
SQL_MAX_CHAR_LITERAL_LEN 131072
SQL_MAX_COLUMN_NAME_LEN 128/30*
SQL_MAX_COLUMNS_IN_GROUP_BY 16
SQL_MAX_COLUMNS_IN_INDEX 16
SQL_MAX_COLUMNS_IN_ORDER_BY 16
SQL_MAX_COLUMNS_IN_SELECT 4000
SQL_MAX_COLUMNS_IN_TABLE 250
SQL_MAX_CONCURRENT_ACTIVITIES 1
SQL_MAX_CURSOR_NAME_LEN 128/30*
SQL_MAX_DRIVER_CONNECTIONS 0
SQL_MAX_IDENTIFIER_LEN 128/30*
SQL_MAX_INDEX_SIZE 127
SQL_MAX_PROCEDURE_NAME_LEN 134/36* (SQL Server procedure names consist of the name (128 bytes in SQL Server 7.0 and 30 bytes in earlier versions), plus an optional colon and a 5 digit number.)
SQL_MAX_ROW_SIZE 8062/1962*
SQL_MAX_ROW_SIZE_INCLUDES_LONG “N”
SQL_MAX_SCHEMA_NAME_LEN 128/30*
SQL_MAX_STATEMENT_LEN 131072
SQL_MAX_TABLE_NAME_LEN 128/30*
SQL_MAX_TABLES_IN_SELECT 16
SQL_MAX_USER_NAME_LEN 128/30*
SQL_MAX_OWNER_NAME_LEN 128/30*
SQL_MAX_QUALIFIER_NAME_LEN 128/30*
SQL_MULT_RESULT_SETS “Y”
SQL_MULTIPLE_ACTIVE_TXN “Y”
SQL_NEED_LONG_DATA_LEN “Y”
SQL_NON_NULLABLE_COLUMNS SQL_NNC_NON_NULL
SQL_NULL_COLLATION SQL_NC_LOW
SQL_NUMERIC_FUNCTIONS SQL_FN_NUM_ABS
SQL_FN_NUM_ACOS
SQL_FN_NUM_ASIN
SQL_FN_NUM_ATAN
SQL_FN_NUM_ATAN2
SQL_FN_NUM_CEILING
SQL_FN_NUM_COS
SQL_FN_NUM_COT
SQL_FN_NUM_DEGREES
SQL_FN_NUM_EXP
SQL_FN_NUM_FLOOR
SQL_FN_NUM_LOG
SQL_FN_NUM_LOG10
SQL_FN_NUM_MOD
SQL_FN_NUM_PI
SQL_FN_NUM_POWER
SQL_FN_NUM_RADIANS
SQL_FN_NUM_RAND
SQL_FN_NUM_ROUND
SQL_FN_NUM_SIGN
SQL_FN_NUM_SIN
SQL_FN_NUM_SQRT
SQL_FN_NUM_TAN
SQL_ODBC_API_CONFORMANCE SQL_OAC_LEVEL2
SQL_ODBC_INTERFACE_CONFORMANCE SQL_OIC_LEVEL2 when connected to SQL Server 7.0

SQL_OIC_CORE when connected to SQL Server 6.5 or earlier.

SQL_ODBC_SAG_CLI_CONFORMANCE SQL_OSCC_NOT_COMPLIANT
SQL_ODBC_SQL_CONFORMANCE SQL_OSC_CORE
SQL_ODBC_SQL_OPT_IEF “Y”
SQL_ODBC_VER Current version number of the ODBC Driver Manager.
SQL_OJ_CAPABILITIES SQL_OJ_ALL_COMPARISON_OPS
SQL_OJ_FULL
SQL_OJ_INNER
SQL_OJ_LEFT
SQL_OJ_NESTED
SQL_OJ_NOT_ORDERED
SQL_OJ_RIGHT
SQL_OUTER_JOINS “Y”
SQL_ORDER_BY_COLUMNS_IN_SELECT “N”
SQL_OWNER_USAGE SQL_OU_DML_STATEMENTS
SQL_OU_INDEX_DEFINITION
SQL_OU_PRIVILEGE_DEFINITION
SQL_OU_PROCEDURE_INVOCATION
SQL_OU_TABLE_DEFINITION
SQL_PARAM_ARRAY_ROW_COUNTS SQL_PARC_BATCH
SQL_PARAM_ARRAY_SELECTS SQL_PAS_BATCH
SQL_POS_OPERATIONS SQL_POS_ADD
SQL_POS_DELETE
SQL_POS_POSITION
SQL_POS_REFRESH
SQL_POS_UPDATE
SQL_POSITIONED_STATEMENTS SQL_PS_POSITIONED_DELETE
SQL_PS_POSITIONED_UPDATE
SQL_PS_SELECT_FOR_UPDATE
SQL_PROCEDURE_TERM “stored procedure”
SQL_PROCEDURES “Y”
SQL_QUALIFIER_USAGE SQL_CU_DML_STATEMENTS SQL_CU_PROCEDURE_INVOCATION
SQL_CU_TABLE_DEFINITION
SQL_QUOTED_IDENTIFIER_CASE SQL_IC_MIXED when connected to a server running a case-insensitive sort order.

SQL_IC_SENSITIVE when connected to a server running a case-sensitive sort order.

SQL_ROW_UPDATES “N”
SQL_SCHEMA_TERM “owner”
SQL_SCHEMA_USAGE SQL_OU_DML_STATEMENTS
SQL_OU_INDEX_DEFINITION
SQL_OU_PRIVILEGE_DEFINITION
SQL_OU_PROCEDURE_INVOCATION
SQL_OU_TABLE_DEFINITION
SQL_SCROLL_OPTIONS SQL_SO_DYNAMIC
SQL_SO_FORWARD_ONLY
SQL_SO_KEYSET_DRIVEN
SQL_SO_STATIC
SQL_SCROLL_CONCURRENCY SQL_SCCO_LOCK
SQL_SCCO_OPT_ROWVER
SQL_SCCO_OPT_VALUES
SQL_SCCO_READ_ONLY
SQL_SEARCH_PATTERN_ESCAPE “\”
SQL_SERVER_NAME The connection’s server name.
SQL_SPECIAL_CHARACTERS Depends on SQL Server-installed character set.
SQL_SQL92_DATETIME_FUNCTIONS FALSE
SQL_SQL92_FOREIGN_KEY_DELETE_RULE FALSE
SQL_SQL92_FOREIGN_KEY_UPDATE_RULE FALSE
SQL_SQL92_GRANT SQL_SG_WITH_GRANT_OPTION
SQL_SQL92_NUMERIC_VALUE_FUNCTIONS FALSE
SQL_SQL92_PREDICATES SQL_SP_EXISTS SQL_SP_ISNOTNULL
SQL_SP_ISNULL
SQL_SQL92_RELATIONAL_JOIN_OPERATORS SQL_SRJO_CROSS_JOIN
SQL_SRJO_FULL_OUTER_JOIN
SQL_SRJO_INNER_JOIN
SQL_SRJO_LEFT_OUTER_JOIN
SQL_SRJO_RIGHT_OUTER_JOIN
SQL_SRJO_UNION_JOIN
SQL_SQL92_REVOKE SQL_SR_GRANT_OPTION_FOR
SQL_SQL92_ROW_VALUE_CONSTRUCTOR SQL_SRVC_DEFAULT
SQL_SRVC_NULL
SQL_SRVC_ROW_SUBQUERY
SQL_SRVC_VALUE_EXPRESSION
SQL_SQL92_STRING_FUNCTIONS SQL_SSF_LOWER
SQL_SSF_UPPER
SQL_SQL92_VALUE_EXPRESSIONS SQL_SVE_CASE
SQL_SVE_CAST
SQL_SVE_COALESCE
SQL_SVE_NULLIF
SQL_STANDARD_CLI_CONFORMANCE SQL_SCC_ISO92_CLI
SQL_STATIC_CURSOR_ATTRIBUTES1 SQL_CA1_ABSOLUTE
SQL_CA1_BOOKMARK
SQL_CA1_BULK_FETCH_BY_BOOKMARK
SQL_CA1_LOCK_NO_CHANGE
SQL_CA1_NEXT
SQL_CA1_POS_POSITION
SQL_CA1_POS_REFRESH
SQL_CA1_RELATIVE
SQL_STATIC_CURSOR_ATTRIBUTES2 SQL_CA2_CRC_EXACT
SQL_CA2_MAX_ROWS_CATALOG
SQL_CA2_MAX_ROWS_DELETE
SQL_CA2_MAX_ROWS_INSERT
SQL_CA2_MAX_ROWS_SELECT
SQL_CA2_MAX_ROWS_UPDATE
SQL_CA2_READ_ONLY_CONCURRENCY
SQL_STATIC_SENSITIVITY SQL_SS_ADDITIONS
SQL_SS_UPDATES
SQL_STRING_FUNCTIONS SQL_FN_STR_ASCII
SQL_FN_STR_BIT_LENGTH
SQL_FN_STR_CHAR
SQL_FN_STR_CONCAT
SQL_FN_STR_DIFFERENCE
SQL_FN_STR_INSERT
SQL_FN_STR_LCASE
SQL_FN_STR_LEFT
SQL_FN_STR_LENGTH
SQL_FN_STR_LOCATE_2
SQL_FN_STR_LTRIM
SQL_FN_STR_OCTET_LENGTH
SQL_FN_STR_REPEAT
SQL_FN_STR_RIGHT
SQL_FN_STR_RTRIM
SQL_FN_STR_SOUNDEX
SQL_FN_STR_SPACE
SQL_FN_STR_SUBSTRING
SQL_FN_STR_UCASE
SQL_SUBQUERIES SQL_SQ_COMPARISON
SQL_SQ_CORRELATED_SUBQUERIES
SQL_SQ_EXISTS
SQL_SQ_IN
SQL_SQ_QUANTIFIED
SQL_SYSTEM_FUNCTIONS SQL_FN_SYS_DBNAME
SQL_FN_SYS_IFNULL
SQL_FN_SYS_USERNAME
SQL_TABLE_TERM “table”
SQL_TIMEDATE_ADD_INTERVALS SQL_FN_TSI_DAY
SQL_FN_TSI_FRAC_SECOND
SQL_FN_TSI_HOUR
SQL_FN_TSI_MINUTE
SQL_FN_TSI_MONTH
SQL_FN_TSI_QUARTER
SQL_FN_TSI_SECOND
SQL_FN_TSI_WEEK
SQL_FN_TSI_YEAR
SQL_TIMEDATE_DIFF_INTERVALS SQL_FN_TSI_DAY
SQL_FN_TSI_FRAC_SECOND
SQL_FN_TSI_HOUR
SQL_FN_TSI_MINUTE
SQL_FN_TSI_MONTH
SQL_FN_TSI_QUARTER
SQL_FN_TSI_SECOND
SQL_FN_TSI_WEEK
SQL_FN_TSI_YEAR
SQL_TIMEDATE_FUNCTIONS SQL_FN_TD_CURDATE
SQL_FN_TD_CURRENT_DATE
SQL_FN_TD_CURRENT_TIME
SQL_FN_TD_CURRENT_TIMESTAMP
SQL_FN_TD_CURTIME
SQL_FN_TD_DAYNAME
SQL_FN_TD_DAYOFMONTH
SQL_FN_TD_DAYOFWEEK
SQL_FN_TD_DAYOFYEAR
SQL_FN_TD_EXTRACT
SQL_FN_TD_HOUR
SQL_FN_TD_MINUTE
SQL_FN_TD_MONTH
SQL_FN_TD_MONTHNAME
SQL_FN_TD_NOW
SQL_FN_TD_QUARTER
SQL_FN_TD_SECOND
SQL_FN_TD_TIMESTAMPADD
SQL_FN_TD_TIMESTAMPDIFF
SQL_FN_TD_WEEK
SQL_FN_TD_YEAR
SQL_TXN_CAPABLE SQL_TC_ALL
SQL_TXN_ISOLATION_OPTION SQL_TXN_READ_COMMITTED
SQL_TXN_READ_UNCOMMITTED
SQL_TXN_REPEATABLE_READ
SQL_TXN_SERIALIZABLE
SQL_UNION SQL_U_UNION
SQL_U_UNION_ALL
SQL_USER_NAME The current username.
*    Dependent on SQL Server version. First value when connected to SQL Server version 7.0 and later; second value for all earlier versions.

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.