PUBS database

Question

Dear friends,
I have trouble finding more detailed information about the tables and fields of the Pubs training database.
Could you help me, please?
Many thanks!!!
Annie

Answer 1

The Pubs database provides a set of fictional pieces of information about publishers, authors, titles and sales of books.

It is now considered obsolete; it is no longer provided with SQL Server since the 2008 version.

The tables and fields should be quite obvious. They have names such as Authors, Titles, etc., which reflect their content. And the fields also have obvious names explaining what they contain.
If you want to explore the relationships between tables (foreign keys) you can use the option to create a database diagram in SQL Server Management Studio (SSMS). Simply add all of the tables in the database to a new diagram and let SSMS arrange them automatically. The Pubs database is small enough that a single diagram can contain all the tables without becoming confusing.

Answer 2

Hi @BIVS Databaze ,
The database we will be using is the PUBS database. The PUBS database includes a fictional set of information about

• publishers,
• authors,
• titles and the sales of their associated books.

The database is often used as a model database that you can experiment with.
When you install many of the different database packages on the market, this database is often included as a learning tool.

Download the script instnwnd.sql from the following GitHub repository to create and load the Northwind sample database for SQL Server:
Northwind and pubs sample databases for Microsoft SQL Server.

Before you can use the Northwind and pubs database, you have to run the downloaded instnwnd.sql script file to recreate the database on an instance of SQL Server by using SQL Server Management Studio or a similar tool. Follow the instructions in the Readme file in the repository.

Note: If you're looking for the Northwind database for Microsoft Access, see Install the Northwind sample database for Microsoft Access.
Hope this helps.
Best Regards,
Joy

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.