Duplicating a Table

See Also

A table can appear only once in a database diagram. However, if you want to create a new table that contains some 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.

Use the same technique for duplicating tables across database diagrams.

To duplicate a table

  1. 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.

    A blank table is added to your diagram.

  2. In the Choose Name dialog box, change the system-assigned name of the new table.

  3. 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.

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