Database reference - AdventureWorks

AdventureWorks -  views

View overview

name created modified columns code length dependents depends on row size comment
[dbo].[RidiculousView] Jul 17 2006 8:27PM Jul 17 2006 8:27PM 8 11,202 0 29 2,201 b this view is ridiculous. 
[HumanResources].[vEmployee] Oct 14 2005 1:59AM Oct 14 2005 1:59AM 17 945 0 9 2,147,484,770 b Employee names and addresses. 
[HumanResources].[vEmployeeDepartment] Oct 14 2005 1:59AM Oct 14 2005 1:59AM 10 691 0 6 656 b Returns employee name, title, and current department. 
[HumanResources].[vEmployeeDepartmentHistory] Oct 14 2005 1:59AM Oct 14 2005 1:59AM 11 714 0 7 672 b Returns employee name and current and previous departments. 
[HumanResources].[vJobCandidate] Oct 14 2005 1:59AM Oct 14 2005 1:59AM 16 3,095 0 2 6,442,451,962 b Job candidate names and resumes. 
[HumanResources].[vJobCandidateEducation] Oct 14 2005 1:59AM Oct 14 2005 1:59AM 13 2,866 0 2 2,147,484,802 b 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. 
[HumanResources].[vJobCandidateEmployment] Oct 14 2005 1:59AM Oct 14 2005 1:59AM 11 2,558 0 2 12,884,902,312 b 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. 
[Person].[vAdditionalContactInfo] Oct 14 2005 1:59AM Oct 14 2005 1:59AM 17 4,204 0 3 6,442,452,230 b Displays the contact name and content from each element in the xml column AdditionalContactInfo for that person. 
[Person].[vStateProvinceCountryRegion] Oct 14 2005 2:00AM Oct 14 2005 2:00AM 7 453 0 5 221 b Joins StateProvince table with CountryRegion table. 
[Production].[vProductAndDescription] Oct 14 2005 1:59AM Oct 14 2005 1:59AM 5 670 0 6 1,016 b Product names and descriptions. Product descriptions are provided in multiple languages. 
[Production].[vProductModelCatalogDescription] Oct 14 2005 1:59AM Oct 14 2005 1:59AM 25 6,422 0 3 6,442,461,374 b Displays the content from each element in the xml column CatalogDescription for each product in the Production.ProductModel table that has catalog data. 
[Production].[vProductModelInstructions] Oct 14 2005 1:59AM Oct 14 2005 1:59AM 11 1,287 0 3 2,147,485,871 b Displays the content from each element in the xml column Instructions for each product in the Production.ProductModel table that has manufacturing instructions. 
[Purchasing].[vVendor] Oct 14 2005 2:00AM Oct 14 2005 2:00AM 17 1,077 0 11 1,224 b Vendor (company) names and addresses and the names of vendor employees to contact. 
[Sales].[vIndividualCustomer] Oct 14 2005 1:59AM Oct 14 2005 1:59AM 17 1,158 0 11 2,147,484,770 b Individual customers (names and addresses) that purchase Adventure Works Cycles products online. 
[Sales].[vIndividualDemographics] Oct 14 2005 1:59AM Oct 14 2005 1:59AM 13 3,080 0 2 254 b Displays the content from each element in the xml column Demographics for each customer in the Sales.Individual table. 
[Sales].[vSalesPerson] Oct 14 2005 1:59AM Oct 14 2005 1:59AM 21 1,215 0 11 1,387 b Sales representiatives (names and addresses) and their sales-related information. 
[Sales].[vSalesPersonSalesByFiscalYears] Oct 14 2005 1:59AM Oct 14 2005 1:59AM 7 1,041 0 7 571 b Uses PIVOT to return aggregated sales information for each sales representative. 
[Sales].[vStoreWithDemographics] Oct 14 2005 2:00AM Oct 14 2005 2:00AM 28 3,508 0 13 1,708 b Stores (names and addresses) that sell Adventure Works Cycles products to consumers. 


Largest views by code length



Documentation generated by SqlSpec