0 out of 1 rated this helpful - Rate this topic

How to: Open Table Designer (Visual Database Tools)

SQL Server 2005

Updated: 12 December 2006

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 will be added to the main menu and the designer panes will open.

Open an existing table

Right-click the table under the Tables node of your database in Object Explorer and click Design (Modify in SP1 or earlier).
The Table Designer menu will be added to the main menu and the table will open in the designer panes.

Other Resources

Understanding Visual Database Tools (Visual Database Tools)
Designing Tables (Visual Database Tools)
Tables

Help and Information

Getting SQL Server 2005 Assistance

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD