OLE DB Programmer's Reference

SQL_LANGUAGES Rowset

GUID: DBSCHEMA_SQL_LANGUAGES

Number of restriction columns: 0

Restriction columns: none

Default sort order: SQL_LANGUAGE_SOURCE

Description: The SQL_LANGUAGES rowset identifies the conformance levels, options, and dialects supported by the SQL-implementation processing data defined in the catalog.

Column name Type indicator Description
SQL_LANGUAGE_SOURCE DBTYPE_WSTR Should be "ISO 9075" for standard SQL.
SQL_LANGUAGE_YEAR DBTYPE_WSTR Should be "1992" for ANSI SQL-92–compliant SQL.
SQL_LANGUAGE_CONFORMANCE DBTYPE_WSTR One of the following:
"ENTRY"
"INTERMEDIATE"
"FULL"
SQL_LANGUAGE_INTEGRITY DBTYPE_WSTR "YES"—Optional integrity feature is supported.

"NO"—Optional integrity feature is not supported.

SQL_LANGUAGE_IMPLEMENTATION DBTYPE_WSTR NULL for "ISO 9075" implementation.
SQL_LANGUAGE_BINDING_STYLE DBTYPE_WSTR "DIRECT" for C/C++ callable direct execution of SQL.
SQL_LANGUAGE_PROGRAMMING_LANGUAGE DBTYPE_WSTR NULL.