Generated using SQL Data Dictionary demo version.
(Last updated on Thu, Nov 26th, 2015 at 12:25 PM)
AdventureWorks 2012 Sample OLTP Database
| dbo.AWBuildVersion
(1 row)
Current version number of the AdventureWorks 2012 sample database. |
Production.ProductModelProductDescriptionCulture
(762 rows)
Cross-reference table mapping product descriptions and the language the description is written in. |
| dbo.DatabaseLog
(1,597 rows)
Audit table tracking all DDL changes made to the AdventureWorks database. Data is captured by the database trigger ddlDatabaseTriggerLog. |
Production.ProductPhoto
(101 rows)
Product images. |
| dbo.ErrorLog
(0 rows)
Audit table tracking errors in the the AdventureWorks database that are caught by the CATCH block of a TRY...CATCH construct. Data is inserted by stored procedure dbo.uspLogError when it is executed from inside the CATCH block of a TRY...CATCH construct. |
Production.ProductProductPhoto
(504 rows)
Cross-reference table mapping products and product photos. |
| HumanResources.Department
(16 rows)
Lookup table containing the departments within the Adventure Works Cycles company. |
Production.ProductReview
(4 rows)
Customer reviews of products they have purchased. |
| HumanResources.Employee
(290 rows)
Employee information such as salary, department, and title. |
Production.ProductSubcategory
(37 rows)
Product subcategories. See ProductCategory table. |
| HumanResources.EmployeeDepartmentHistory
(296 rows)
Employee department transfers. |
Production.ScrapReason
(16 rows)
Manufacturing failure reasons lookup table. |
| HumanResources.EmployeePayHistory
(316 rows)
Employee pay history. |
Production.TransactionHistory
(113,443 rows)
Record of each purchase order, sales order, or work order transaction year to date. |
| HumanResources.JobCandidate
(13 rows)
Résumés submitted to Human Resources by job applicants. |
Production.TransactionHistoryArchive
(89,253 rows)
Transactions for previous years. |
| HumanResources.Shift
(3 rows)
Work shift lookup table. |
Production.UnitMeasure
(38 rows)
Unit of measure lookup table. |
| Person.Address
(19,614 rows)
Street address information for customers, employees, and vendors. |
Production.WorkOrder
(72,591 rows)
Manufacturing work orders. |
| Person.AddressType
(6 rows)
Types of addresses stored in the Address table. |
Production.WorkOrderRouting
(67,131 rows)
Work order details. |
| Person.BusinessEntity
(20,777 rows)
Source of the ID that connects vendors, customers, and employees with address and contact information. |
Purchasing.ProductVendor
(460 rows)
Cross-reference table mapping vendors with the products they supply. |
| Person.BusinessEntityAddress
(19,614 rows)
Cross-reference table mapping customers, vendors, and employees to their addresses. |
Purchasing.PurchaseOrderDetail
(8,845 rows)
Individual products associated with a specific purchase order. See PurchaseOrderHeader. |
| Person.BusinessEntityContact
(909 rows)
Cross-reference table mapping stores, vendors, and employees to people |
Purchasing.PurchaseOrderHeader
(4,012 rows)
General purchase order information. See PurchaseOrderDetail. |
| Person.ContactType
(20 rows)
Lookup table containing the types of business entity contacts. |
Purchasing.ShipMethod
(5 rows)
Shipping company lookup table. |
| Person.CountryRegion
(238 rows)
Lookup table containing the ISO standard codes for countries and regions. |
Purchasing.Vendor
(104 rows)
Companies from whom Adventure Works Cycles purchases parts or other goods. |
| Person.EmailAddress
(19,972 rows)
Where to send a person email. |
Sales.CountryRegionCurrency
(109 rows)
Cross-reference table mapping ISO currency codes to a country or region. |
| Person.Password
(19,972 rows)
One way hashed authentication information |
Sales.CreditCard
(19,118 rows)
Customer credit card information. |
| Person.Person
(19,972 rows)
Human beings involved with AdventureWorks: employees, customer contacts, and vendor contacts. |
Sales.Currency
(105 rows)
Lookup table containing standard ISO currencies. |
| Person.PersonPhone
(19,972 rows)
Telephone number and type of a person. |
Sales.CurrencyRate
(13,532 rows)
Currency exchange rates. |
| Person.PhoneNumberType
(3 rows)
Type of phone number of a person. |
Sales.Customer
(19,820 rows)
Current customer information. Also see the Person and Store tables. |
| Person.StateProvince
(181 rows)
State and province lookup table. |
Sales.PersonCreditCard
(19,118 rows)
Cross-reference table mapping people to their credit card information in the CreditCard table. |
| Production.BillOfMaterials
(2,679 rows)
Items required to make bicycles and bicycle subassemblies. It identifies the heirarchical relationship between a parent product and its components. |
Sales.SalesOrderDetail
(121,317 rows)
Individual products associated with a specific sales order. See SalesOrderHeader. |
| Production.Culture
(8 rows)
Lookup table containing the languages in which some AdventureWorks data is stored. |
Sales.SalesOrderHeader
(31,465 rows)
General sales order information. |
| Production.Document
(13 rows)
Product maintenance documents. |
Sales.SalesOrderHeaderSalesReason
(27,647 rows)
Cross-reference table mapping sales orders to sales reason codes. |
| Production.Illustration
(5 rows)
Bicycle assembly diagrams. |
Sales.SalesPerson
(17 rows)
Sales representative current information. |
| Production.Location
(14 rows)
Product inventory and manufacturing locations. |
Sales.SalesPersonQuotaHistory
(163 rows)
Sales performance tracking. |
| Production.Product
(504 rows)
Products sold or used in the manfacturing of sold products. |
Sales.SalesReason
(10 rows)
Lookup table of customer purchase reasons. |
| Production.ProductCategory
(4 rows)
High-level product categorization. |
Sales.SalesTaxRate
(29 rows)
Tax rate lookup table. |
| Production.ProductCostHistory
(395 rows)
Changes in the cost of a product over time. |
Sales.SalesTerritory
(10 rows)
Sales territory lookup table. |
| Production.ProductDescription
(762 rows)
Product descriptions in several languages. |
Sales.SalesTerritoryHistory
(17 rows)
Sales representative transfers to other sales territories. |
| Production.ProductDocument
(32 rows)
Cross-reference table mapping products to related product documents. |
Sales.ShoppingCartItem
(3 rows)
Contains online customer orders until the order is submitted or cancelled. |
| Production.ProductInventory
(1,069 rows)
Product inventory information. |
Sales.SpecialOffer
(16 rows)
Sale discounts lookup table. |
| Production.ProductListPriceHistory
(395 rows)
Changes in the list price of a product over time. |
Sales.SpecialOfferProduct
(538 rows)
Cross-reference table mapping products to special offer discounts. |
| Production.ProductModel
(128 rows)
Product model classification. |
Sales.Store
(701 rows)
Customers (resellers) of Adventure Works products. |
| Production.ProductModelIllustration
(7 rows)
Cross-reference table mapping product models and illustrations. |
| HumanResources.vEmployee Employee names and addresses. |
Production.vProductModelInstructions Displays the content from each element in the xml column Instructions for each product in the Production.ProductModel table that has manufacturing instructions. |
| HumanResources.vEmployeeDepartment Returns employee name, title, and current department. |
Purchasing.vVendorWithAddresses Vendor (company) names and addresses . |
| HumanResources.vEmployeeDepartmentHistory Returns employee name and current and previous departments. |
Purchasing.vVendorWithContacts Vendor (company) names and the names of vendor employees to contact. |
| HumanResources.vJobCandidate Job candidate names and resumes. |
Sales.vIndividualCustomer Individual customers (names and addresses) that purchase Adventure Works Cycles products online. |
| HumanResources.vJobCandidateEducation 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. |
Sales.vPersonDemographics Displays the content from each element in the xml column Demographics for each customer in the Person.Person table. |
| HumanResources.vJobCandidateEmployment 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. |
Sales.vSalesPerson Sales representiatives (names and addresses) and their sales-related information. |
| Person.vAdditionalContactInfo Displays the contact name and content from each element in the xml column AdditionalContactInfo for that person. |
Sales.vSalesPersonSalesByFiscalYears Uses PIVOT to return aggregated sales information for each sales representative. |
| Person.vStateProvinceCountryRegion Joins StateProvince table with CountryRegion table. |
Sales.vStoreWithAddresses Stores (including store addresses) that sell Adventure Works Cycles products to consumers. |
| Production.vProductAndDescription Product names and descriptions. Product descriptions are provided in multiple languages. |
Sales.vStoreWithContacts Stores (including store contacts) that sell Adventure Works Cycles products to consumers. |
| Production.vProductModelCatalogDescription Displays the content from each element in the xml column CatalogDescription for each product in the Production.ProductModel table that has catalog data. |
Sales.vStoreWithDemographics Stores (including demographics) that sell Adventure Works Cycles products to consumers. |
| dbo.uspGetBillOfMaterials Stored procedure using a recursive query to return a multi-level bill of material for the specified ProductID. |
dbo.uspPrintError Prints error information about the error that caused execution to jump to the CATCH block of a TRY...CATCH construct. Should be executed from within the scope of a CATCH block otherwise it will return without printing any error information. |
| dbo.uspGetEmployeeManagers Stored procedure using a recursive query to return the direct and indirect managers of the specified employee. |
dbo.uspSearchCandidateResumes |
| dbo.uspGetManagerEmployees Stored procedure using a recursive query to return the direct and indirect employees of the specified manager. |
HumanResources.uspUpdateEmployeeHireInfo Updates the Employee table and inserts a new row in the EmployeePayHistory table with the values specified in the input parameters. |
| dbo.uspGetWhereUsedProductID Stored procedure using a recursive query to return all components or assemblies that directly or indirectly use the specified ProductID. |
HumanResources.uspUpdateEmployeeLogin Updates the Employee table with the values specified in the input parameters for the given BusinessEntityID. |
| dbo.uspLogError Logs error information in the ErrorLog table about the error that caused execution to jump to the CATCH block of a TRY...CATCH construct. Should be executed from within the scope of a CATCH block otherwise it will return without inserting error information. |
HumanResources.uspUpdateEmployeePersonalInfo Updates the Employee table with the values specified in the input parameters for the given EmployeeID. |
| dbo.ufnGetAccountingEndDate Scalar function used in the uSalesOrderHeader trigger to set the starting account date. |
dbo.ufnGetProductStandardCost Scalar function returning the standard cost for a given product on a particular order date. |
| dbo.ufnGetAccountingStartDate Scalar function used in the uSalesOrderHeader trigger to set the ending account date. |
dbo.ufnGetPurchaseOrderStatusText Scalar function returning the text representation of the Status column in the PurchaseOrderHeader table. |
| dbo.ufnGetContactInformation Table value function returning the first name, last name, job title and contact type for a given contact. |
dbo.ufnGetSalesOrderStatusText Scalar function returning the text representation of the Status column in the SalesOrderHeader table. |
| dbo.ufnGetDocumentStatusText Scalar function returning the text representation of the Status column in the Document table. |
dbo.ufnGetStock Scalar function returning the quantity of inventory in LocationID 6 (Miscellaneous Storage)for a specified ProductID. |
| dbo.ufnGetProductDealerPrice Scalar function returning the dealer price for a given product on a particular order date. |
dbo.ufnLeadingZeros Scalar function used by the Sales.Customer table to help set the account number. |
| dbo.ufnGetProductListPrice Scalar function returning the list price for a given product on a particular order date. |