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.
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.aspxHow to ask: http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxFor ultra basic questions, follow these links.http://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp |
|
|
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 |
|
|
|
|
|