Xml Schema: KrystianSchemaProducts

Properties

Property	Value
Name	KrystianSchemaProducts
ID	65543
Schema	dbo
Owner	JohnBlack
Modify Date	1/2/2011 4:36:38 AM
Create Date	1/2/2011 4:17:02 AM

Extended Properties

Name	Value
MS_Description	mobi XXX

[KrystianSchemaProducts] is used in the following columns

Xml Collection is not used in any columns

[KrystianSchemaProducts] is used in the following parameters

Xml Collection is not used in any parameters

Xml Namespaces

ID	Name
1

Permissions

No object level permissions defined.

Objects that depend on [KrystianSchemaProducts]

dbo.KrystianSchemaProducts

Objects on which [KrystianSchemaProducts] depends

dbo.KrystianSchemaProducts

SQL

Script
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'

Script

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'