| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | helpviewer_keywords | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
SQL Conformance Levels |
SQL Conformance Levels |
David-Engel |
davidengel |
01/19/2017 |
sql |
connectivity |
conceptual |
|
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.)