Database Examples/Pubs

Microsoft Pubs is a database sample that is available to download with the Microsoft SQL Server application.^[1] The Pubs database is available under a Microsoft Public License.^[2]

Please note the Pubs database is an older database example that does not follow the current database naming conventions. The following sample database is a subset supporting the original Pubs database and is used for educational benefits.

Entity-Relationship Diagram

Tables

• Jobs
• Publishers
• Employees
• Titles
• Titleauthor
• Stores
• Discounts
• Authors
• Sales

SQL Scripts

• SQL Server

See Also

• Red-Gate: Pubs Sample Database Diagram
• GitHub: Northwind and pubs sample databases for Microsoft SQL Server

References