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:

C# in Depth, 3rd EditionManaged Windows VPS Hosting

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.