SQL_FEATURES

Information on SQL features and their subfeatures in the implemented language environment. All designations are defined in the SQL standard.

Column name

Data type

Contents

FEATURE_ID

VARCHAR (256)

Feature ID (e.g. F111)

FEATURE_NAME

VARCHAR (256)

Feature name (e.g. “Isolation levels other
than SERIALIZABLE”)

SUB_FEATURE_ID

VARCHAR (256)

Subfeature ID (e.g. 02)

SUB_FEATURE_NAME

VARCHAR (256)

Subfeature name (e.g. “READ COMITTED
isolation level”)

IS_SUPPORTED

VARCHAR (3)

YES	Fully supported
NO	Not supported or only partially supported

IS_VERIFIED_BY

VARCHAR (256)

NULL value

COMMENTS

VARCHAR (256)

Comments

Table 90: SQL_FEATURES view of the INFORMATION_SCHEMA