Interview Questions Answers.ORG
Interviewer And Interviewee Guide
Interviews
Quizzes
Home
Quizzes
Interviews Databases Programming Interviews:BtrieveClipperData ModelingData StructuresDatabase AdministrationDatabase Administrator (DBA)Database AnalystDatabase DeveloperDB DevelopmentEDI/Data Integration ExpertFirebirdHierarchicalIBM DB2InformixJava DatabaseMariaDBMicrosoft Access DeveloperMongoDBMS SQL ServerMySQL ProgrammingNetworkNoSQLObject RelationalPostgrePostgreSQLProgressRDBMSRelationalSQLSQL AdministratorSQL and PL/SQLSQL Notification ServicesSQL server 2008SSRSStored ProcedureSybaseTeradata
Copyright © 2018. All Rights Reserved
MS SQL Server Interview Question:
How AdventureWorksLT tables are related?
Submitted by: AdministratorThere 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
<pre>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</pre>
Here is an ER (Entity Relation) diagram presented on Jasmin's photo galary:
AdventureWorksLT ER Diagram.
Submitted by: Administrator
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
<pre>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</pre>
Here is an ER (Entity Relation) diagram presented on Jasmin's photo galary:
AdventureWorksLT ER Diagram.
Submitted by: Administrator
Copyright 2007-2024 by Interview Questions Answers .ORG All Rights Reserved.
https://InterviewQuestionsAnswers.ORG.
https://InterviewQuestionsAnswers.ORG.