Export (0) Print
Expand All
0 out of 3 rated this helpful - Rate this topic

Open Table Designer (Visual Database Tools)

The Table Designer is a visual tool that allows you to design and visualize database tables to which you are connected. You can use Table Designer to create, edit, or delete tables, columns, keys, indexes, relationships, and constraints.

You can open Table Designer by opening a new or existing table.

Open a new table

  • Right-click the Tables node of your database in Object Explorer and click New Table.

    The Table Designer menu is added to the main menu and the designer panes open.

Note Note

If you are connected to a SQL Azure database, the new table option will launch a create table template script. Edit the parameters, then run the script to create a new table. For more information, see SQL Azure Overview.

Open an existing table

  • Right-click the table under the Tables node of your database in Object Explorer and click Modify.

    The Table Designer menu is added to the main menu and the table opens in the designer panes.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.