SQL conformance levels

 

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, Intermediate, or Full levels defined in SQL-92. ODBC defines its own set of SQL grammar conformance levels as Minimum, Core and Extended. Because ODBC SQL grammar conformance levels are guidelines rather than restrictions, applications are free to send any SQL statement to a data source, even if the statement is not described within the ODBC SQL conformance level the driver claims to be conformant to. Drivers can support additional SQL statements and, in fact, they may provide all of the functionality defined by the SQL-92 Entry, Intermediate, and/or Full SQL functionality level. However, if a driver claims to conform to a specific ODBC SQL conformance level, it must support all of the functionality defined by that conformance level.