How to open a table in Table Designer

Developers can open in SQL Server “Denali”, MS SQL Server 2008 R2 and MS SQL Server 2005 Table Designer to view or edit its structure, by following the next steps:

1. From the View menu, click Object Explorer.

2. In Object Explorer, right-click the database table they want to open and click Design (Modify in SP1 or earlier).

The table opens in Table Designer.