2.1.2.79 F502-01, SQL_SIZING_PROFILES view

V0115

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

 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 varies as follows:

Transact-SQL does not support this feature.

Microsoft SQL Server 2012 varies as follows:

This feature is absent in the [ISO/IEC9075-11:2011] specification.