| title | SQL Conformance Levels | ||||
|---|---|---|---|---|---|
| description | SQL Conformance Levels | ||||
| author | David-Engel | ||||
| ms.author | davidengel | ||||
| ms.date | 01/19/2017 | ||||
| ms.service | sql | ||||
| ms.subservice | connectivity | ||||
| ms.topic | conceptual | ||||
| helpviewer_keywords |
|
The level of SQL-92 grammar supported by a driver is indicated by the value returned by a call to SQLGetInfo with the SQL_SQL_CONFORMANCE information type. This indicates whether the driver conforms to the Entry, FIPS Transitional, Intermediate, or Full levels defined in SQL-92.
All ODBC drivers must support the minimum SQL grammar described in SQL Minimum Grammar in Appendix C: SQL Grammar. This grammar is a subset of the Entry level of SQL-92. Drivers may support additional SQL and be conformant to the SQL-92 Entry, Intermediate, or Full level, or to the FIPS 127-2 Transitional level. Drivers that comply to a given level of SQL-92 or FIPS 127-2 can support additional features in any of the higher levels yet not be fully conformant to that level. To determine whether a feature is supported, an application should call SQLGetInfo with the appropriate information type. The conformance level of a SQL feature is described in the corresponding information type. (See the SQLGetInfo function description.)