Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
V0122:
The specification states the following:
-
Subclause 20.3, "ATTRIBUTES view": Without Feature X160, "Basic Information Schema for registered XML Schemas", conforming SQL language shall not reference INFORMATION_SCHEMA.ATTRIBUTES.XML_SCHEMA_CATALOG, INFORMATION_SCHEMA.ATTRIBUTES.XML_SCHEMA_SCHEMA, or INFORMATION_SCHEMA.ATTRIBUTES.XML_SCHEMA_NAME. Subclause 20.4, "COLUMNS view": Without Feature X160, "Basic Information Schema for registered XML Schemas", conforming SQL language shall not reference INFORMATION_SCHEMA.COLUMNS.XML_SCHEMA_CATALOG, INFORMATION_SCHEMA.COLUMNS.XML_SCHEMA_SCHEMA, or INFORMATION_SCHEMA.COLUMNS.XML_SCHEMA_NAME. Subclause 20.5, "DOMAINS view": Without Feature X160, "Basic Information Schema for registered XML Schemas", conforming SQL language shall not reference INFORMATION_SCHEMA.DOMAINS.XML_SCHEMA_CATALOG, INFORMATION_SCHEMA.DOMAINS.XML_SCHEMA_SCHEMA, or INFORMATION_SCHEMA.DOMAINS.XML_SCHEMA_NAME. Subclause 20.6, "ELEMENT_TYPES view": Without Feature X160, "Basic Information Schema for registered XML Schemas", conforming SQL language shall not reference INFORMATION_SCHEMA.ELEMENT_TYPES.XML_SCHEMA_CATALOG, INFORMATION_SCHEMA.ELEMENT_TYPES.XML_SCHEMA_SCHEMA, or INFORMATION_SCHEMA.ELEMENT_TYPES.XML_SCHEMA_NAME. Subclause 20.7, "FIELDS view": Without Feature X160, "Basic Information Schema for registered XML Schemas", conforming SQL language shall not reference INFORMATION_SCHEMA.FIELDS.XML_SCHEMA_CATALOG, INFORMATION_SCHEMA.FIELDS.XML_SCHEMA_SCHEMA, or INFORMATION_SCHEMA.FIELDS.XML_SCHEMA_NAME. Subclause 20.8, "METHOD_SPECIFICATION_PARAMETERS view": Without Feature X160, "Basic Information Schema for registered XML Schemas", conforming SQL language shall not reference INFORMATION_SCHEMA.METHOD_SPECIFICATION_PARAMETERS.XML_SCHEMA_CATALOG, INFORMATION_SCHEMA.METHOD_SPECIFICATION_PARAMETERS.XML_SCHEMA_SCHEMA, or INFORMATION_SCHEMA.METHOD_SPECIFICATION_PARAMETERS.XML_SCHEMA_NAME. Subclause 20.9, "METHOD_SPECIFICATIONS view": Without Feature X160, "Basic Information Schema for registered XML Schemas", conforming SQL language shall not reference INFORMATION_SCHEMA.METHOD_SPECIFICATIONS.XML_SCHEMA_CATALOG, INFORMATION_SCHEMA.METHOD_SPECIFICATIONS.XML_SCHEMA_SCHEMA, INFORMATION_SCHEMA.METHOD_SPECIFICATIONS.XML_SCHEMA_NAME, INFORMATION_SCHEMA.METHOD_SPECIFICATION_PARAMETERS.RESULT_CAST_XML_SCHEMA_CATALOG, INFORMATION_SCHEMA.METHOD_SPECIFICATION_PARAMETERS.RESULT_CAST_XML_SCHEMA_SCHEMA, or INFORMATION_SCHEMA.METHOD_SPECIFICATION_PARAMETERS.RESULT_CAST_XML_SCHEMA_NAME. Subclause 20.10, "PARAMETERS view": Without Feature X160, "Basic Information Schema for registered XML Schemas", conforming SQL language shall not reference reference INFORMATION_SCHEMA.PARAMETERS.XML_SCHEMA_CATALOG, INFORMATION_SCHEMA.PARAMETERS.XML_SCHEMA_SCHEMA, or INFORMATION_SCHEMA.PARAMETERS.XML_SCHEMA_NAME. Subclause 20.11, "ROUTINES view": Without Feature X160, "Basic Information Schema for registered XML Schemas", conforming SQL language shall not reference INFORMATION_SCHEMA.ROUTINES.XML_SCHEMA_CATALOG, INFORMATION_SCHEMA.ROUTINES.XML_SCHEMA_SCHEMA, INFORMATION_SCHEMA.ROUTINES.XML_SCHEMA_NAME, NFORMATION_SCHEMA.ROUTINES.RESULT_CAST_XML_SCHEMA_CATALOG, INFORMATION_SCHEMA.ROUTINES.RESULT_CAST_XML_SCHEMA_SCHEMA, or INFORMATION_SCHEMA.ROUTINES.RESULT_CAST_XML_SCHEMA_NAME. Subclause 20.14, "XML_SCHEMAS view": Without Feature X160, "Basic Information Schema for registered XML Schemas", conforming SQL language shall not reference INFORMATION_SCHEMA.XML_SCHEMAS. Subclause 20.15, "Short name views": Without Feature X160, "Basic Information Schema for registered XML Schemas", conforming SQL language shall not reference INFORMATION_SCHEMA.XML_SCHEMAS_S. 92)
Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 vary as follows:
Transact-SQL does not support this feature. However, it does support equivalent catalog views. See "XML Schemas (XML Type System) Catalog Views (Transact-SQL)" in [MSDN-Transact-SQLRef] for more information.
See [ISO/IEC9075-1:2011] for the definition of "view".
This variation pertains to XML 1.0 [XML10/5] functionality in SQL Server.