AdventureWorks2014

• Tables

  • dbo.AWBuildVersion

  • dbo.DatabaseLog

  • dbo.ErrorLog

  • HumanResources.Department

  • HumanResources.Employee

  • HumanResources.EmployeeDepartmentHistory

  • HumanResources.EmployeePayHistory

  • HumanResources.JobCandidate

  • HumanResources.Shift

  • Person.Address

  • Person.AddressType

  • Person.BusinessEntity

  • Person.BusinessEntityAddress

  • Person.BusinessEntityContact

  • Person.ContactType

  • Person.CountryRegion

  • Person.EmailAddress

  • Person.Password

  • Person.Person

  • Person.PersonPhone

  • Person.PhoneNumberType

  • Person.StateProvince

  • Production.BillOfMaterials

  • Production.Culture

  • Production.Document

  • Production.Illustration

  • Production.Location

  • Production.Product

  • Production.ProductCategory

  • Production.ProductCostHistory

  • Production.ProductDescription

  • Production.ProductDocument

  • Production.ProductInventory

  • Production.ProductListPriceHistory

  • Production.ProductModel

  • Production.ProductModelIllustration

  • Production.ProductModelProductDescriptionCulture

  • Production.ProductPhoto

  • Production.ProductProductPhoto

  • Production.ProductReview

  • Production.ProductSubcategory

  • Production.ScrapReason

  • Production.TransactionHistory

  • Production.TransactionHistoryArchive

  • Production.UnitMeasure

  • Production.WorkOrder

  • Production.WorkOrderRouting

  • Purchasing.ProductVendor

  • Purchasing.PurchaseOrderDetail

  • Purchasing.PurchaseOrderHeader

  • Purchasing.ShipMethod

  • Purchasing.Vendor

  • Sales.CountryRegionCurrency

  • Sales.CreditCard

  • Sales.Currency

  • Sales.CurrencyRate

  • Sales.Customer

  • Sales.PersonCreditCard

  • Sales.SalesOrderDetail

  • Sales.SalesOrderHeader

  • Sales.SalesOrderHeaderSalesReason

  • Sales.SalesPerson

  • Sales.SalesPersonQuotaHistory

  • Sales.SalesReason

  • Sales.SalesTaxRate

  • Sales.SalesTerritory

  • Sales.SalesTerritoryHistory

  • Sales.ShoppingCartItem

  • Sales.SpecialOffer

  • Sales.SpecialOfferProduct

  • Sales.Store

• Views

  • HumanResources.vEmployee

  • HumanResources.vEmployeeDepartment

  • HumanResources.vEmployeeDepartmentHistory

  • HumanResources.vJobCandidate

  • HumanResources.vJobCandidateEducation

  • HumanResources.vJobCandidateEmployment

  • Person.vAdditionalContactInfo

  • Person.vStateProvinceCountryRegion

  • Production.vProductAndDescription

  • Production.vProductModelCatalogDescription

  • Production.vProductModelInstructions

  • Purchasing.vVendorWithAddresses

  • Purchasing.vVendorWithContacts

  • Sales.vIndividualCustomer

  • Sales.vPersonDemographics

  • Sales.vSalesPerson

  • Sales.vSalesPersonSalesByFiscalYears

  • Sales.vStoreWithAddresses

  • Sales.vStoreWithContacts

  • Sales.vStoreWithDemographics

• Procedures

  • dbo.uspGetBillOfMaterials

  • dbo.uspGetEmployeeManagers

  • dbo.uspGetManagerEmployees

  • dbo.uspGetWhereUsedProductID

  • dbo.uspLogError

  • dbo.uspPrintError

  • dbo.uspSearchCandidateResumes

  • HumanResources.uspUpdateEmployeeHireInfo

  • HumanResources.uspUpdateEmployeeLogin

  • HumanResources.uspUpdateEmployeePersonalInfo

• Functions

  • dbo.ufnGetAccountingEndDate

  • dbo.ufnGetAccountingStartDate

  • dbo.ufnGetContactInformation

  • dbo.ufnGetDocumentStatusText

  • dbo.ufnGetProductDealerPrice

  • dbo.ufnGetProductListPrice

  • dbo.ufnGetProductStandardCost

  • dbo.ufnGetPurchaseOrderStatusText

  • dbo.ufnGetSalesOrderStatusText

  • dbo.ufnGetStock

  • dbo.ufnLeadingZeros