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 |
|
mflammia
Starting Member
44 Posts |
 Posted - 2008-11-11 : 15:38:43
|
| Have a large SQL DB that has been developed on the backend of my website but have no idea what and how the tables have been composed and linked together.Is there anything I can use to visualise this?Many thanks |
|
|
mflammia
Starting Member
44 Posts |
Posted - 2008-11-11 : 15:46:05
|
| I probably should have mentioned that I am running queries on this as a linked server through studio express and do not have direct access to the database server itself |
 |
|
|
hanbingl
Aged Yak Warrior
652 Posts |
Posted - 2008-11-11 : 15:52:26
|
| do you mean an ER diagram? you can use visio to reverse engineering ER diagram. |
|
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2008-11-11 : 16:01:58
|
| Viso is the best option to creating your own, or have you not tried asking the person that developed the back end sql server db for a ER Diagram showing the relationships |
|
|
|
mflammia
Starting Member
44 Posts |
Posted - 2008-11-11 : 16:10:11
|
| Well asking my developers was my first course of action but the response is slow to not at all. ER diagram, yes, thats exactly what I need. Thought there might be some kind of tool I could use that would query the DB and create one - is there such a thing I could use as a novice?Thanks. |
|
|
|
hanbingl
Aged Yak Warrior
652 Posts |
Posted - 2008-11-11 : 16:21:34
|
| Microsoft Visio. Here is the "Step-by-Step Guide to Reverse Engineering a Database in Visio 2000"http://msdn.microsoft.com/en-us/library/aa140264(office.10).aspx |
|
|
|
|
|
|
Visualise DB