Duplicating a Table

Visual Database Tools

Visual Database Tools

Duplicating a Table

A table can appear only once in a database diagram. However, if you want to create a new table that contains some or all of the same columns as an existing table in your diagram, you can duplicate the existing table as the first step in creating your new table. Then in your new table, you can delete unwanted columns, add new columns, and assign a unique table name.

Note   This operation duplicates only a table's structure; it does not duplicate any table rows.

Use the same technique for duplicating tables across database diagrams.

To duplicate a table

In the database diagram where you want to duplicate the table, right-click the diagram and choose New Table from the shortcut menu.
-or-
Click the New Table button on the Database Diagram toolbar.

  1. In the Choose Name dialog box, accept or change the system-assigned name of the new table and click OK.
    A blank table is added to your diagram.

  2. In the table you want to duplicate, select all the columns. This table can be in the same diagram, a different diagram in the same database, or a diagram in a different database.

  3. Copy the columns to the blank table. For details about copying columns, see Copying Columns from One Table to Another.

See Also

Tables