# Xml Schema: StoreSurveySchemaCollection

## Properties

Property | Value
--- | ---
Name | StoreSurveySchemaCollection
ID | 65541
Schema | Sales
Owner | dbo
Modify Date | 8/8/2010 5:21:46 PM
Create Date | 8/8/2010 5:21:46 PM

## Extended Properties

Name | Value
--- | ---
MS_Description | Collection of XML schemas for the Demographics column in the Sales.Store table. mobi

## [StoreSurveySchemaCollection] is used in the following columns

Schema | Object | Column
--- | --- | ---
Sales | Store | Demographics

## [StoreSurveySchemaCollection] is used in the following parameters

Xml Collection is not used in any parameters

## Xml Namespaces

ID | Name
--- | ---
1 | http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/StoreSurvey

## Permissions

No object level permissions defined.

## Objects that depend on [StoreSurveySchemaCollection]

- Sales.StoreSurveySchemaCollection
  - Sales.Store
    - Sales.Customer
      - Sales.SalesOrderHeader
        - Sales.SalesOrderDetail
          - Sales.iduSalesOrderDetail
          - Sales.ufn_SalesByStore
        - Sales.SalesOrderHeaderSalesReason
        - Sales.uSalesOrderHeader
        - Sales.vSalesPersonSalesByFiscalYears
      - dbo.ufnGetContactInformation
      - Sales.vIndividualCustomer
    - Sales.vStoreWithAddresses
    - Sales.vStoreWithContacts
    - Sales.vStoreWithDemographics

## Objects on which [StoreSurveySchemaCollection] depends

- Sales.StoreSurveySchemaCollection

## SQL

Script
CREATE XML SCHEMA COLLECTION [Sales].[StoreSurveySchemaCollection] AS N'<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:t="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/StoreSurvey" targetNamespace="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/StoreSurvey" elementFormDefault="qualified"><xsd:element name="StoreSurvey"><xsd:complexType><xsd:complexContent><xsd:restriction base="xsd:anyType"><xsd:sequence><xsd:element name="ContactName" type="xsd:string" minOccurs="0" /><xsd:element name="JobTitle" type="xsd:string" minOccurs="0" /><xsd:element name="AnnualSales" type="xsd:decimal" minOccurs="0" /><xsd:element name="AnnualRevenue" type="xsd:decimal" minOccurs="0" /><xsd:element name="BankName" type="xsd:string" minOccurs="0" /><xsd:element name="BusinessType" type="t:BusinessType" minOccurs="0" /><xsd:element name="YearOpened" type="xsd:gYear" minOccurs="0" /><xsd:element name="Specialty" type="t:SpecialtyType" minOccurs="0" /><xsd:element name="SquareFeet" type="xsd:float" minOccurs="0" /><xsd:element name="Brands" type="t:BrandType" minOccurs="0" /><xsd:element name="Internet" type="t:InternetType" minOccurs="0" /><xsd:element name="NumberEmployees" type="xsd:int" minOccurs="0" /><xsd:element name="Comments" type="xsd:string" minOccurs="0" /></xsd:sequence></xsd:restriction></xsd:complexContent></xsd:complexType></xsd:element><xsd:simpleType name="BrandType"><xsd:restriction base="xsd:string"><xsd:enumeration value="AW" /><xsd:enumeration value="2" /><xsd:enumeration value="3" /><xsd:enumeration value="4+" /></xsd:restriction></xsd:simpleType><xsd:simpleType name="BusinessType"><xsd:restriction base="xsd:string"><xsd:enumeration value="BM" /><xsd:enumeration value="BS" /><xsd:enumeration value="D" /><xsd:enumeration value="OS" /><xsd:enumeration value="SGS" /></xsd:restriction></xsd:simpleType><xsd:simpleType name="InternetType"><xsd:restriction base="xsd:string"><xsd:enumeration value="56kb" /><xsd:enumeration value="ISDN" /><xsd:enumeration value="DSL" /><xsd:enumeration value="T1" /><xsd:enumeration value="T2" /><xsd:enumeration value="T3" /></xsd:restriction></xsd:simpleType><xsd:simpleType name="SpecialtyType"><xsd:restriction base="xsd:string"><xsd:enumeration value="Family" /><xsd:enumeration value="Kids" /><xsd:enumeration value="BMX" /><xsd:enumeration value="Touring" /><xsd:enumeration value="Road" /><xsd:enumeration value="Mountain" /><xsd:enumeration value="All" /></xsd:restriction></xsd:simpleType></xsd:schema>' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Collection of XML schemas for the Demographics column in the Sales.Store table. mobi' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'XML SCHEMA COLLECTION',@level1name=N'StoreSurveySchemaCollection'

#### See also

List of Xml Collections