Dear friends,
I'm looking for a description of the tables and fields of the Pubs training database. Can you help me please?
Thank you very much,
Anna
Dear friends,
I'm looking for a description of the tables and fields of the Pubs training database. Can you help me please?
Thank you very much,
Anna
Hi @BIVSDatabaze-5379, we have not get a reply from you. Did any answers could help you? If there has an answer helped, please do "Accept Answer". If not, please let us know. By doing so, it will benefit for community members who have this similar issue. Your contribution is highly appreciated. Thank you!
Hi,
The pubs database is a sample of a publishing company, which includes books, authors, sales and stores.
It includes the tables: authors,publishers,titles,titleauthor,stores,sales,roysched,discounts,jobs,pub_info,employee
here you can see the diagram of the database:
For more information you can simply go over the scrip which create the database and all it's entities:
https://github.com/microsoft/sql-server-samples/blob/master/samples/databases/northwind-pubs/instpubs.sql
Welcome to Microsoft Q&A!
After researched, there doesn't have much information about the tables and fields of the Pubs database in English. However, I found a documents about Pubs database analysis for SQL Server 2000. But the document is write by Chinese, I have translated for the first part(the blue part). You could use Google translation if the document are useful.
And the Entity Relationship Diagram of Pubs Database as below:
Best regards,
Carrin
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.
11 people are following this question.
Year and Month aggregation in same Pivot table in SQL Server
SQL Server Query for Searching by word in a string with word breakers
How to show first row group by part id and compliance type based on priorities of Document type?
Query to list all the databases that have a specific user
T-sql query to find the biggest table in a database with a clustered index