Database Visualisation Tool ? Developing in SQL

[Sinizter]

I am trying to create a database with multiple tables and relationships - with queries needing data from multiple tables, etc.

Ive got most of it worked out in my head. But I was wondering if there was a database visualisation tool available so that I could visually look at everything and move things around as necessary.

Preferably freeware. I have seen an option (shareware) that allows this as well as generates the create table scripts for SQL etc.

The database will probably be accessed over the internet with the use of PHP and mySQL once I get it all figured out.

[b0redom]

http://www.phpmyadmin.net/home_page/index.php

or

http://www.toadsoft.com/

[TiG]

Whats wrong with Database diagrams in SQL Server itself?

EDIT: ignore sorry didn't see mysql mentioned in the thread.

TiG

[Spud1]

toad is a very nice tool, although its not quite as graphical as I think you want (not the free version anyway), its more of a DBA tool for when your database it up and running.

The tool I use to design my databases is Microsoft Visio - it ships with some good templates for database design, and can output SQL for you at the end of it..it can even reverse engineer your database for you and produce a diagam. Its not free of course, but there is a free trial you can get http://ukireland.trymicrosoftoffice.com/

[b0redom]

Does it talk anything else apart from Microsoft though?

[Spud1]

UML...there are thousands of custom templates out there too if you don't fancy using Microsofts', but the UML templates in visio are fairly good IMO.