>>Can anybody recommend a good product for creating a database structure diagram? Ideally, I would like it to look like what you get when you use MODIFY DATABASE, but neater. I would like it to show the connections between the tables, listing which fields are linked, and if it's a one-to-many relationship, and for the lines to adjust themselves if I move the tables in the diagram. Since I'm working with a large database, I'd like to be able to import it, without having to type in every table, field and link. I tried using Visio, but I cannot get the lines (that show the links) to move when I move the tables. Also, it didn't import all of the links that connect the tables. Any suggestions?
>>
>>Jerry
>
>VisioModeler, formerly InfoModeler, is now freeware. I wrote an article about it, Universal Thread Magazine, May 2006.
http://www.levelextreme.com/ViewPageArticle.aspx?Session=4E2B314F346C70334470633D204A5050484E6A716B4572324177484F414D74613237413D3DThanks.
Someone recommends
http://sourceforge.net/projects/dbdesigner-fork/
If it's not broken, fix it until it is.
My Blog