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
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.