All sample databasesPubs
Publishing · pubs.demodb.dev
Pubs
sample database.
Microsoft's classic publishing sample database, with authors, books, publishers, stores, sales, and publisher-logo images.
-- Titles by publisher
SELECT titles.title, publishers.pub_name, titles.price FROM
11 tables · 1 views · 255 rows
-- 2 high-confidence cross-database table matches
11tables
1views
255table rows
Schema at a glance
Browse the recordsets.
table authors Authors represented in the Pubs title catalogue. 9 columns · 0 links · 23 rows table discounts Initial, volume, and store-specific sales discounts. 5 columns · 1 links · 3 rows table employee Employees, their job levels, hire dates, and publisher assignments. 8 columns · 2 links · 43 rows · 2 matches in other samples table jobs Job titles and the permitted employee job-level range. 4 columns · 0 links · 14 rows table pub_info Publisher descriptions and the original GIF logos stored as BLOBs. 3 columns · 1 links · 8 rows table publishers Publishing organizations, contact details, and locations. 5 columns · 0 links · 8 rows table roysched Royalty percentages for title sales across sales-range bands. 4 columns · 1 links · 86 rows table sales Recorded sales by store, order number, date, title, quantity, and payment terms. 6 columns · 2 links · 21 rows table stores Retail stores that sell Pubs publications. 6 columns · 0 links · 6 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.