Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Database Question

Author  Topic 

jscot
Posting Yak Master

106 Posts

Posted - 2010-08-18 : 22:58:42
I have OLTP database Name "ABC" and "ABC" database has 45 tables.
I have task to create reports. I know the fields but i don't know the tables. what is the best and fastest way to find out required tables and relation between. I can through reverse engineering to (Data Modeling tools "Erwin" or "MS Visio") check through database diagram. I just want to know is there any other fastest way. Thanks in advance.

DonAtWork
Master Smack Fu Yak Hacker

2167 Posts

Posted - 2010-08-19 : 06:56:06
You should REALLY learn the data model if you are going to report on the data. just knowing the column names is NOT going to cut it. Erwin is a very good tool. It would REALLY help you a LOT more if you could talk to the DBA about the database.

http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx
How to ask: http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

For ultra basic questions, follow these links.
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp
Go to Top of Page

denis_the_thief
Aged Yak Warrior

596 Posts

Posted - 2010-08-19 : 10:48:47
- Expand database in Management Studio
- Right Click on Database Diagrams -> New database Diagram
- Add tables to Diagram and the Relationships will appear
Go to Top of Page
   

- Advertisement -