Database design software?

[notfred]

Is there any software that will allow you to diagram tables and thier relationship to one another, while graphically showing all your tables on one screen at the same time?

It's difficult to picture relations and redundancy between tables without being able to see a list of the fields in the database at once.

 

[jjungman]

Well, Visio is cool and all, but are you looking for something that is open source?

 

[mugs]

Microsoft Access (relationships screen)
Microsoft Visio (you can do it by hand or import from Access, a very nice feature)
There's a few I've found on download.com (search ERD or entity relationship diagram), but I haven't found any free ones that were worth using.

 

[bchalker]

I'm not sure, but Filemaker Pro might be a good one. (This is a designer, not a programmer, saying this, so take it as such )

 

[Templeton]

Have used before for mysql... should be able to find similiar programs for other database servers.

 

[Iluvatar]

How about DBDesigner 4? It's open source and seems pretty good.

 

[MrChad]

Visio will generate ER diagrams automatically.

 

[kamper]

Are you the one who was bitching about UML the other day? That's kinda funny...