Hello,
I would like to know what are the different type of Database design tools.I am currently using SQL server 7.0.
please help..
thank you

There are three major players I've used:

Computer Associates ERWin
http://www3.ca.com/Solutions/Product.asp?ID=260

Embarcadero ER/Studio
http://www.embarcadero.com/products/erstudio/index.html

Microsoft Visio
http://office.microsoft.com/home/off...tid=FX01085798

xcase is pretty good
http://www.xcase.com

CAST Software is a good one. It's user interface isn't very friendly but it does a whole lot of stuff. I switched from Embarcadero's products to CAST a little over a year ago. Embarcadero's tools started getting real buggy after version 5.1.

CAST can reverse engineer about any language and can run reports and impact analysis on changes throughout an entire application. This has been very helpful when I make db changes because our .NET and java developers always forget to update code to handle my changes.

http://www.castsoftware.com