XML schema collection: [AdventureWorks2016CTP3].[Production].[ManuInstructionsSchemaCollection]

CollapseAll image

Collapse image XML schema collection properties


Name  Value 
 Schema   [Production] 
 Owner   [dbo] 
 ID   65540 

Collapse image Objects that depend on [Production].[ManuInstructionsSchemaCollection]


Object name Object type Dep level
[Production].[ProductModel] Table 1
Total 1 object(s)

Collapse image Objects that [Production].[ManuInstructionsSchemaCollection] depends on


Object name Object type Dep level
[Production] Schema 1
Total 1 object(s)

Collapse image Extended properties


Name  Value 
MS_Description Collection of XML schemas for the Instructions column in the Production.ProductModel table.

Collapse image SQL


CREATE XML SCHEMA COLLECTION [Production].[ManuInstructionsSchemaCollection] AS
N'<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:t="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductM
    odelManuInstructions" targetNamespace="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelManuInstructions"
     elementFormDefault="qualified"><xsd:element name="root"><xsd:complexType mixed="true"><xsd:complexContent mixed="true"><xsd:restriction
     base="xsd:anyType"><xsd:sequence><xsd:element name="Location" maxOccurs="unbounded"><xsd:complexType mixed="true"><xsd:complexContent
     mixed="true"><xsd:restriction base="xsd:anyType"><xsd:sequence><xsd:element name="step" type="t:StepType" maxOccurs="unbounded" /></xsd:sequence><
    xsd:attribute name="LocationID" type="xsd:integer" use="required" /><xsd:attribute name="SetupHours" type="xsd:decimal" /><xsd:attribute
     name="MachineHours" type="xsd:decimal" /><xsd:attribute name="LaborHours" type="xsd:decimal" /><xsd:attribute name="LotSize" type="xsd:decimal"
     /></xsd:restriction></xsd:complexContent></xsd:complexType></xsd:element></xsd:sequence></xsd:restriction></xsd:complexContent></x
    sd:complexType></xsd:element><xsd:complexType name="StepType" mixed="true"><xsd:complexContent mixed="true"><xsd:restriction base="xsd:an
    yType"><xsd:choice minOccurs="0" maxOccurs="unbounded"><xsd:element name="tool" type="xsd:string" /><xsd:element name="material"
     type="xsd:string" /><xsd:element name="blueprint" type="xsd:string" /><xsd:element name="specs" type="xsd:string" /><xsd:element name="diag"
     type="xsd:string" /></xsd:choice></xsd:restriction></xsd:complexContent></xsd:complexType></xsd:schema>'
GO
EXEC sp_addextendedproperty
     N'MS_Description', N'Collection of XML schemas for the Instructions column in the Production.ProductModel table.', 'SCHEMA', N'Production',
     'XML SCHEMA COLLECTION', N'ManuInstructionsSchemaCollection', NULL, NULL
GO

Collapse image See also


List of XML schema collections