AdventureWorksLT Entity Relation Diagram in SQL Server

Q

How AdventureWorksLT tables are related in SQL Server?

✍: FYIcenter.com

A

There are 12 user tables defined in AdventureWorksLT:

USE AdventureWorksLT
GO 

SELECT s.name, t.name, t.type_desc
   FROM sys.tables t, sys.schemas s
   WHERE t.schema_id = s.schema_id
   ORDER BY s.name
GO
s.name  t.name                          t.type_desc
dbo     BuildVersion                    USER_TABLE
dbo     ErrorLog                        USER_TABLE
SalesLT Address                         USER_TABLE
SalesLT Customer                        USER_TABLE
SalesLT CustomerAddress                 USER_TABLE
SalesLT Product                         USER_TABLE
SalesLT ProductCategory                 USER_TABLE
SalesLT ProductDescription              USER_TABLE
SalesLT ProductModel                    USER_TABLE
SalesLT ProductModelProductDescription  USER_TABLE
SalesLT SalesOrderDetail                USER_TABLE
SalesLT SalesOrderHeader                USER_TABLE

Here is an ER (Entity Relation) diagram presented on Jasmin's photo gallery:
AdventureWorksLT ER Diagram.

 

Installing Sample Scripts and Databases in SQL Server

⇒⇒SQL Server Database Tutorials

2016-12-02, 275👍, 0💬