2.1.2.78 F502, Enhanced documentation tables

V0114

The [ISO/IEC9075-11:2011] specification states the following:

 Subclause 5.57, "SQL_IMPLEMENTATION_INFO view":
  
 Function
  
 List the SQL-implementation information items defined in this standard and, for each of these, indicate the value supported by the SQL-implementation.
  
 Definition
  
 CREATE VIEW SQL_IMPLEMENTATION_INFO AS
 SELECT IMPLEMENTATION_INFO_ID, IMPLEMENTATION_INFO_NAME,
 INTEGER_VALUE, CHARACTER_VALUE, COMMENTS
 FROM DEFINITION_SCHEMA.SQL_IMPLEMENTATION_INFO;
  
 GRANT SELECT ON TABLE SQL_IMPLEMENTATION_INFO
 TO PUBLIC WITH GRANT OPTION;
  
 Conformance Rules
  
 Without Feature F502, "Enhanced documentation tables", conforming SQL language shall not reference INFORMATION_SCHEMA.SQL_IMPLEMENTATION_INFO.
  
 Subclause 5.58, "SQL_PARTS view":
  
 Function
  
 List the parts of this standard, and indicate which of these the SQL-implementation supports.
  
 Definition
  
 CREATE VIEW SQL_PARTS AS
 SELECT ID AS PART, NAME, IS_SUPPORTED, IS_VERIFIED_BY, COMMENTS
 FROM DEFINITION_SCHEMA.SQL_CONFORMANCE
 WHERE TYPE = 'PART';
  
 GRANT SELECT ON TABLE SQL_PARTS
 TO PUBLIC WITH GRANT OPTION;
  
 Conformance Rules
  
 Without Feature F502, "Enhanced documentation tables", conforming SQL language shall not reference INFORMATION_SCHEMA.SQL_PARTS.
  
 Subclause 5.81, "Short name views":
  
 CREATE VIEW SQL_IMPL_INFO
 ( IMPL_INFO_ID, IMPL_INFO_NAME, INTEGER_VALUE,
 CHARACTER_VALUE, COMMENTS ) AS
 SELECT IMPLEMENTATION_INFO_ID, IMPLEMENTATION_INFO_NAME, INTEGER_VALUE,
 CHARACTER_VALUE, COMMENTS
 FROM INFORMATION_SCHEMA.SQL_IMPLEMENTATION_INFO;
  
 GRANT SELECT ON TABLE SQL_IMPL_INFO
 TO PUBLIC WITH GRANT OPTION;
  
 CREATE VIEW SQL_SIZING_PROFS
 ( SIZING_ID,   SIZING_NAME,   PROFILE_ID,
 PROFILE_NAME,  REQUIRED_VALUE,  COMMENTS ) AS
 SELECT SIZING_ID, SIZING_NAME, PROFILE_ID,
 PROFILE_NAME, REQUIRED_VALUE, COMMENTS
 FROM INFORMATION_SCHEMA.SQL_SIZING_PROFILES;
  
 GRANT SELECT ON TABLE SQL_SIZING_PROFS
 TO PUBLIC WITH GRANT OPTION;
  
 ...
  
 Conformance Rules
  
 Without Feature F502, "Enhanced documentation tables", conforming SQL language shall not reference INFORMATION_SCHEMA.SQL_IMPL_INFO.
  
 Without Feature F502, "Enhanced documentation tables", conforming SQL language shall not reference INFORMATION_SCHEMA.SQL_SIZING_PROFS.

The following additional subclauses are present in the [ISO/IEC9075-11:2008] specification:

 Subclause 5.54, "SQL_PACKAGES view":
  
 Function
  
 List the packages of this standard, and indicate which of these the SQL-implementation supports.
  
 Definition
  
 CREATE VIEW SQL_PACKAGES AS
 SELECT ID, NAME, IS_SUPPORTED, IS_VERIFIED_BY, COMMENTS
 FROM DEFINITION_SCHEMA.SQL_CONFORMANCE
 WHERE TYPE = 'PACKAGE';
  
 GRANT SELECT ON TABLE SQL_PACKAGES
 TO PUBLIC WITH GRANT OPTION;
  
 Conformance Rules
  
 Without Feature F502, "Enhanced documentation tables", conforming SQL language shall not reference INFORMATION_SCHEMA.SQL_PACKAGES.
  
 Subclause 5.57, "SQL_SIZING_PROFILES view":
  
 Function
  
 List the sizing items defined in this standard and, for each of these, indicate the size required by one or more profiles of the standard.
  
 Definition
  
 CREATE VIEW SQL_SIZING_PROFILES AS
 SELECT SIZING_ID, SS.SIZING_NAME, SSP.PROFILE_ID,
 SSP.PROFILE_NAME, SSP.REQUIRED_VALUE, SSP.COMMENTS
 FROM DEFINITION_SCHEMA.SQL_SIZING_PROFILES AS SSP
 JOIN
 DEFINITION_SCHEMA.SQL_SIZING AS SS
 USING ( SIZING_ID );
  
 GRANT SELECT ON TABLE SQL_SIZING_PROFILES
 TO PUBLIC WITH GRANT OPTION;
  
 Conformance Rules
  
 Without Feature F502, "Enhanced documentation tables", conforming SQL language shall not reference INFORMATION_SCHEMA.SQL_SIZING_PROFILES.

Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 vary as follows:

Transact-SQL does not support this feature.