PDA

View Full Version : sql to graphical representasion


Tussi
01-16-2007, 05:46 AM
I have made a database with tables and columns with datatypes and foreign keys and all that. The queries to make it I stored in a sql-file so that I can quickly rebuild the database structure if I ruin it (which will probably happen.. :rolleyes: )

anyways, what I am wondering about is if there is a program, preferably free, that can take this sql file and make a nice graphical representation of it?

i want this because I would like to have a visual aid to look at when I program the php that will use this database, and also to have more to blow away the guy who will grade my report ;) (but mostly the first part.. he-he)

flann
01-24-2007, 03:55 PM
you can check out mysql workbench (if you're using mysql). Just make sure you have a back up of the database that you're working with.

If you're using mssql server, check out your enterprise manager, i can't remember where you do it, but somewhere in there you can export it to an ER diagram.

if you're using anything else, i can't help ya :).