Collections:
AdventureWorksLT Entity Relation Diagram in SQL Server
How AdventureWorksLT tables are related in SQL Server?
✍: FYIcenter.com
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:
.
2016-12-02, 2273👍, 0💬
Popular Posts:
How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...
How To Enter Unicode Character String Literals in SQL Server Transact-SQL? Unicode characters are mu...
How To Get Year, Month and Day Out of DATETIME Values in SQL Server Transact-SQL? You can use DATEPA...
How To Get the Definition of a User Defined Function Back in SQL Server Transact-SQL? If you want ge...
What Do You Need to Connect PHP to MySQL in MySQL? If you want to access MySQL database server in yo...