Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Open Table Designer (Visual Database Tools)

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.

Community Additions

ADD
Show:
© 2015 Microsoft