Database Objects AdventureWorks
wikibot
Tables
EmployeeAddress (HumanResources)
EmployeeDepartmentHistory (HumanResources)
EmployeePayHistory (HumanResources)
ProductCostHistory (Production)
ProductDescription (Production)
ProductListPriceHistory (Production)
ProductModelIllustration (Production)
ProductModelProductDescriptionCulture (Production)
ProductProductPhoto (Production)
ProductSubcategory (Production)
PurchaseOrderDetail (Purchasing)
PurchaseOrderHeader (Purchasing)
SalesOrderHeaderSalesReason (Sales)
SalesPersonQuotaHistory (Sales)
TransactionHistory (Production)
TransactionHistoryArchive (Production)
Views
vAdditionalContactInfo (Person)
vEmployeeDepartment (HumanResources)
vEmployeeDepartmentHistory (HumanResources)
vIndividualDemographics (Sales)
vJobCandidate (HumanResources)
vJobCandidateEducation (HumanResources)
vJobCandidateEmployment (HumanResources)
vProductAndDescription (Production)
vProductModelCatalogDescription (Production)
vProductModelInstructions (Production)
vSalesPersonSalesByFiscalYears (Sales)
vStateProvinceCountryRegion (Person)
vStoreWithDemographics (Sales)
Procedures
uspGetWhereUsedProductID (dbo)
uspUpdateEmployeeHireInfo (HumanResources)
uspUpdateEmployeeLogin (HumanResources)
uspUpdateEmployeePersonalInfo (HumanResources)
Functions
ufnGetAccountingStartDate (dbo)
ufnGetDocumentStatusText (dbo)
ufnGetProductDealerPrice (dbo)
ufnGetProductStandardCost (dbo)
ufnGetPurchaseOrderStatusText (dbo)