Open Table Designer (Visual Database Tools)
The Table Designer is a visual tool that allows you to design and visualize database tables to which you are connected. You can use Table Designer to create, edit, or delete tables, columns, keys, indexes, relationships, and constraints.
You can open Table Designer by opening a new or existing table.
Open a new table
Right-click the Tables node of your database in Object Explorer and click New Table.
The Table Designer menu is added to the main menu and the designer panes open.
Note
If you are connected to a SQL Azure database, the new table option will launch a create table template script. Edit the parameters, then run the script to create a new table. For more information, see SQL Azure Overview.
Open an existing table
Right-click the table under the Tables node of your database in Object Explorer and click Modify.
The Table Designer menu is added to the main menu and the table opens in the designer panes.