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
AdventureWorksLT ER Diagram

 

Adding Address Records into AdventureWorksLT in SQL Server

Attaching AdventureWorksLT Physical Files to the Server in SQL Server

Installing Sample Scripts and Databases in SQL Server

⇑⇑ SQL Server Database Tutorials

2016-12-02, 7369🔥, 0💬