>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

I also would recommend xCase (I actually left a post about it earlier, but it got eaten up by the increasingly sluggish and unreliable UT.)

With xCase you can maintain your entire datamodel, create graphic and non-graphic reports on just about any aspect of your datamodel that you care to think of, as well as generate SQL scripts to replicate your datamodel in a number of different systems, such as Oracle, SQL Server, MySQL, DB2, InterBase, Sybase or, heck, even VFP if you are so inclined. An additional perk for VFP developers is that xCase maintains its metadata in Fox tables, so making difficult sounding batch modifications to the system through the back door is easy as pie.