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:
.
⇒ Adding Address Records into AdventureWorksLT in SQL Server
⇐ Attaching AdventureWorksLT Physical Files to the Server in SQL Server
2016-12-02, 4560👍, 0💬
Popular Posts:
How to create new tables with "CREATE TABLE" statements in SQL Server? If you want to create a new t...
Where to find answers to frequently asked questions on Introduction to Date and Time Handling in MyS...
How To Format DATETIME Values to Strings with the CONVERT() Function in SQL Server Transact-SQL? SQL...
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...
How to download and install Microsoft .NET Framework Version 2.0 in SQL Server? .NET Framework Versi...