AdventureWorksLT Entity Relation Diagram in SQL Server


How AdventureWorksLT tables are related in SQL Server?



There are 12 user tables defined in AdventureWorksLT:

USE AdventureWorksLT

SELECT,, t.type_desc
   FROM sys.tables t, sys.schemas s
   WHERE t.schema_id = s.schema_id
GO                          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.


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, 4560👍, 0💬