Views

	Name	Owner	Schema bound	Encrypted	Creation Date	Modification Date	Description
	vAdditionalContactInfo	Person			04/26/2006	04/26/2006	Displays the contact name and content from each element in the xml column AdditionalContactInfo for that person.
	vEmployee	HumanResources			04/26/2006	07/20/2008	Employee names and addresses.
	vEmployeeDepartment	HumanResources			04/26/2006	04/26/2006	Returns employee name, title, and current department.
	vEmployeeDepartmentHistory	HumanResources			04/26/2006	04/26/2006	Returns employee name and current and previous departments.
	View_1	dbo			09/11/2008	09/11/2008
	vIndividualCustomer	Sales			04/26/2006	04/26/2006	Individual customers (names and addresses) that purchase Adventure Works Cycles products online.
	vIndividualDemographics	Sales			04/26/2006	04/26/2006	Displays the content from each element in the xml column Demographics for each customer in the Sales.Individual table.
	vJobCandidate	HumanResources			04/26/2006	04/26/2006	Job candidate names and resumes.
	vJobCandidateEducation	HumanResources			04/26/2006	04/26/2006	Displays the content from each education related element in the xml column Resume in the HumanResources.JobCandidate table. The content has been localized into French, Simplified Chinese and Thai. Some data may not display correctly unless supplemental language support is installed.
	vJobCandidateEmployment	HumanResources			04/26/2006	04/26/2006	Displays the content from each employement history related element in the xml column Resume in the HumanResources.JobCandidate table. The content has been localized into French, Simplified Chinese and Thai. Some data may not display correctly unless supplemental language support is installed.
	vProductAndDescription	Production			04/26/2006	04/26/2006	Product names and descriptions. Product descriptions are provided in multiple languages.
	vProductModelCatalogDescription	Production			04/26/2006	04/26/2006	Displays the content from each element in the xml column CatalogDescription for each product in the Production.ProductModel table that has catalog data.
	vProductModelInstructions	Production			04/26/2006	04/26/2006	Displays the content from each element in the xml column Instructions for each product in the Production.ProductModel table that has manufacturing instructions.
	vSalesPerson	Sales			04/26/2006	04/26/2006	Sales representiatives (names and addresses) and their sales-related information.
	vSalesPersonSalesByFiscalYears	Sales			04/26/2006	04/26/2006	Uses PIVOT to return aggregated sales information for each sales representative.
	vStateProvinceCountryRegion	Person			04/26/2006	04/26/2006	Joins StateProvince table with CountryRegion table.
	vStoreWithDemographics	Sales			04/26/2006	04/26/2006	Stores (names and addresses) that sell Adventure Works Cycles products to consumers.
	vVendor	Purchasing			04/26/2006	04/26/2006	Vendor (company) names and addresses and the names of vendor employees to contact.

Total: 18 view(s)

See Also

Database overview