Home >> FAQs/Tutorials >> SQL Server FAQ

SQL Server FAQ - AdventureWorksLT Entity Relation Diagram

By: FYIcenter.com

(Continued from previous topic...)

How AdventureWorksLT tables are related?

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 galary:
.

(Continued on next topic...)

1. What Samples and Sample Databases Are Provided by Microsoft?
2. How to download and install SQL Server 2005 Sample Scripts?
3. How to download and install the scaled-down database AdventureWorksLT?
4. How to attach AdventureWorksLT physical files to the server?
5. How AdventureWorksLT tables are related?
6. How to add an address record into AdventureWorksLT?