Is there any SQL Server database designer software like MySQL workbench?

Question

I need to design database for SQL Server, is there any MySQL workbench like software for that? I have access to MSDN, so it can also be commercial product that can be found form MSDN.

Answer 1

SQL Server ships with SQL Server Management Studio which is probably what most SQL developers use to develop in T-SQL and do basic schema management.

There are also a myriad of third party products like the following:

http://www.sql-workbench.net/