How to open an existing table in Table Designer in SQL server

The Table Designer is a visual tool that allows developers to design and visualize database tables to which they are connected. Developers use Table Designer to create, edit, or delete tables, columns, keys, indexes, relationships, and constraints. When developers working with SQL Server “Denali”, MS SQL Server 2008 R2 and MS SQL Server 2005 want to open an existing table, they should follow the next steps:

1. Right-click the table under the Tables node of their database in Object Explorer and click Design (Modify in SP1 or earlier).

2. The Table Designer menu will be added to the main menu and the table will open in the designer panes.