SQL_LANGUAGES
The SQL_LANGUAGES system view lists all the SQL standards and SQL dialects to which the SQL product claims conformance (including subsets defined by ISO and vendor-specific versions).
All versions can be shown in a single table. Each row has at least the columns described below, however additional columns may be specified for an individual vendor or specific international standard.
Column name
|
Data type
|
Description
|
| SOURCE |
VARCHAR(254) |
The organization that defined the SQL version. |
| SOURCE_YEAR |
VARCHAR(254) |
The year the relevant source document was approved. |
| CONFORMANCE |
VARCHAR(254) |
The conformance level to the relevant document that the implementation claims. |
| INTEGRITY |
VARCHAR(254) |
(Meaning no longer defined). |
| IMPLEMENTATION |
VARCHAR(254) |
A character string, defined by the vendor, that uniquely defines the vendor's SQL product. |
| BINDING_STYLE |
VARCHAR(254) |
Included to envisage future adoption of direct, module or other binding styles. |
| PROGRAMMING
_LANG |
VARCHAR(254) |
The host language for which the binding style is supported. |
