All sample databasesAdventureWorks OLTP
Sales, purchasing, manufacturing, and inventory · adventureworks.demodb.dev
AdventureWorks OLTP
sample database.
Microsoft AdventureWorks OLTP sample database with people, products, sales, purchasing, manufacturing, and inventory.
-- Orders by customer
SELECT h."SalesOrderNumber", c."CustomerID", h."OrderDate", h."TotalDue"
71 tables · 11 views · 759,240 rows
-- 3 high-confidence cross-database table matches
71tables
11views
759,240table rows
Schema at a glance
Browse the recordsets.
table HumanResources.Department Lookup table containing the departments within the Adventure Works Cycles company. 4 columns · 0 links · 16 rows table HumanResources.Employee Employee information such as salary, department, and title. 16 columns · 1 links · 290 rows · 3 matches in other samples table HumanResources.EmployeeDepartmentHistory Employee department transfers. 6 columns · 3 links · 296 rows table HumanResources.EmployeePayHistory Employee pay history. 5 columns · 1 links · 316 rows table HumanResources.JobCandidate Résumés submitted to Human Resources by job applicants. 4 columns · 1 links · 13 rows table HumanResources.Shift Work shift lookup table. 5 columns · 0 links · 3 rows table Person.Address Street address information for customers, employees, and vendors. 9 columns · 1 links · 19,614 rows table Person.AddressType Types of addresses stored in the Address table. 4 columns · 0 links · 6 rows table Person.BusinessEntity Source of the ID that connects vendors, customers, and employees with address and contact information. 3 columns · 0 links · 20,777 rows
Downloads
Use this fixture
where you work.
Available files are generated from the provider’s pinned database contract. Pick a complete database or a single table.