Working with Tables in Table Designer

The Table Designer allows you to change an existing database by changing, adding, duplicating, and deleting tables.

Note

A new version of Table Designer appears for databases in the SQL Server 2012 format. This topic describes the old version of Table Designer, which you use with databases in earlier formats of SQL Server.

In the new version, you can change a table definition through a graphical interface or directly in a script pane. If you use the graphical interface, the table’s definition is automatically updated in the script pane. To apply the SQL code in the script pane, choose the Update button. For more information about the new version, see How to: Create Database Objects Using Table Designer.

In This Section

  • How to: Save Your Work in Table Designer
    Provides steps for saving changes to specific tables or to all tables open in the Table Designer.

  • Working with Columns
    Describes what you can do with columns in Visual Database Tools and provides links to topics explaining how to modify columns.

  • Working with Scripts
    Describes what you can do with scripts in Visual Database Tools and provides links to topics explaining how to create and modify them.

  • Understanding Visual Database Tools
    Introduces the elements that make up Visual Database Tools and provides links to conceptual topics about the various tools and their interactions.