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.