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

#### See also

List of Xml Collections