DB Designer - fabFORCE.net Database Tools
dbForge SQL Complete - Try Intellisense functionality and Improved SQL Formatter in SQL Server Management Studio and Visual Studio using SQL Complete!
Vertabelo - Online tool for visual database design.
Dataedo - Database documentation tool
DeZign for Databases - Database design and modeling tool - DeZign for Databases.
SQL Doc by Red Gate - Document your databases automatically.