How to: Open Tables (Visual Database Tools)
You can open a table in Table Designer to view or edit its structure. Note that Table Designer does not commit changes you make to the table until you save your changes.
To open a table in Table Designer
From the View menu, click Object Explorer.
In Object Explorer, right-click the database table you want to open and click Design.
The table opens in Table Designer.