CREATE XML SCHEMA COLLECTION [dbo].[KrystianSchemaProducts] AS N'<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified"><xsd:element name="Products"><xsd:complexType><xsd:complexContent><xsd:restriction base="xsd:anyType"><xsd:sequence><xsd:element name="Product" maxOccurs="unbounded"><xsd:complexType><xsd:complexContent><xsd:restriction base="xsd:anyType"><xsd:sequence><xsd:element name="Name" type="xsd:string" /><xsd:element name="Price" type="xsd:decimal" /></xsd:sequence></xsd:restriction></xsd:complexContent></xsd:complexType></xsd:element></xsd:sequence></xsd:restriction></xsd:complexContent></xsd:complexType></xsd:element></xsd:schema>' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'mobi XXX' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'XML SCHEMA COLLECTION',@level1name=N'KrystianSchemaProducts'
|