Database reference - AdventureWorks2008

AdventureWorks2008 -  views

View overview

name created modified columns code length dependents depends on row size comment
vEmployee Mar 19 2009 9:10PM Mar 19 2009 9:10PM 18 1,314 0 11 2,147,486,086 b Employee names and addresses. 
vEmployeeDepartment Mar 19 2009 9:10PM Mar 19 2009 9:10PM 10 703 0 5 1,279 b Returns employee name, title, and current department. 
vEmployeeDepartmentHistory Mar 19 2009 9:10PM Mar 19 2009 9:10PM 11 738 0 6 1,282 b Returns employee name and current and previous departments. 
vJobCandidate Mar 19 2009 9:10PM Mar 19 2009 9:10PM 16 3,101 0 1 6,442,452,957 b Job candidate names and resumes. 
vJobCandidateEducation Mar 19 2009 9:10PM Mar 19 2009 9:10PM 13 2,866 0 1 2,147,485,907 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. 
vJobCandidateEmployment Mar 19 2009 9:10PM Mar 19 2009 9:10PM 11 2,558 0 1 12,884,902,702 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. 
vAdditionalContactInfo Mar 19 2009 9:10PM Mar 19 2009 9:10PM 17 4,210 0 2 6,442,453,481 b Displays the contact name and content from each element in the xml column AdditionalContactInfo for that person. 
vStateProvinceCountryRegion Mar 19 2009 9:10PM Mar 19 2009 9:10PM 7 453 1 4 432 b Joins StateProvince table with CountryRegion table. 
vProductAndDescription Mar 19 2009 9:10PM Mar 19 2009 9:10PM 5 670 1 5 2,028 b Product names and descriptions. Product descriptions are provided in multiple languages. 
vProductModelCatalogDescription Mar 19 2009 9:10PM Mar 19 2009 9:10PM 25 6,422 0 2 6,442,471,769 b Displays the content from each element in the xml column CatalogDescription for each product in the Production.ProductModel table that has catalog data. 
vProductModelInstructions Mar 19 2009 9:10PM Mar 19 2009 9:10PM 11 1,287 0 2 2,147,487,994 b Displays the content from each element in the xml column Instructions for each product in the Production.ProductModel table that has manufacturing instructions. 
vVendorWithAddresses Mar 19 2009 9:10PM Mar 19 2009 9:10PM 9 811 0 7 1,464 b Vendor (company) names and addresses . 
vVendorWithContacts Mar 19 2009 9:10PM Mar 19 2009 9:10PM 12 936 0 9 1,580 b Vendor (company) names and the names of vendor employees to contact. 
vIndividualCustomer Mar 19 2009 9:10PM Mar 19 2009 9:10PM 18 1,395 0 12 2,147,486,086 b Individual customers (names and addresses) that purchase Adventure Works Cycles products online. 
vPersonDemographics Mar 19 2009 9:10PM Mar 19 2009 9:10PM 13 3,079 0 1 409 b Displays the content from each element in the xml column Demographics for each customer in the Person.Person table. 
vSalesPerson Mar 19 2009 9:10PM Mar 19 2009 9:10PM 22 1,571 0 13 2,864 b Sales representiatives (names and addresses) and their sales-related information. 
vSalesPersonSalesByFiscalYears Mar 19 2009 9:10PM Mar 19 2009 9:10PM 7 1,056 0 6 1,036 b Uses PIVOT to return aggregated sales information for each sales representative. 
vStoreWithAddresses Mar 19 2009 9:10PM Mar 19 2009 9:10PM 9 801 0 7 1,464 b Stores (including store addresses) that sell Adventure Works Cycles products to consumers. 
vStoreWithContacts Mar 19 2009 9:10PM Mar 19 2009 9:10PM 12 928 0 9 1,580 b Stores (including store contacts) that sell Adventure Works Cycles products to consumers. 
vStoreWithDemographics Mar 19 2009 9:10PM Mar 19 2009 9:10PM 12 2,263 0 2 892 b Stores (including demographics) that sell Adventure Works Cycles products to consumers. 


Largest views by code length



Documentation generated by SqlSpec