dbForge Studio for SQL Server
All-in-One SQL Server GUI Tool
A powerful integrated development environment for SQL Server development, management, administration, data analysis, and reporting
Table designer contains visual editors for:
It also contains T-SQL editor that allows you to edit any part of CREATE TABLE manually. The program automatically parses text that you enter and displays all the modifications in the visual editor on the fly.
Synchronization of the visual editor and T-SQL editor. For a column that is selected in the visual editor, the respective SQL syntax is highlighted in the T-SQL editor.
Automatic prompts of data types. Table designer prompts you with data type automatically based on the column name that you entered. You can change it manually if needed.
Self-documented table. Ability to document table by adding comments to a column. All comments are stored as extensive properties thus making a database self-documented.
ALTER TABLE preview. You can preview ALTER TABLE scripts before update a database. Or in some cases, you need to generate a script to apply on remote server. This preview option will allow you to avoid mistakes.
Table rebuild. Some changes made to the table can not be applied using ALTER TABLE. For instance, you need to change a column data type that is not compatible with existing one, or insert a column between the existing ones. Table designer allows to rebuild table without loosing its data.