How to copy a table from another database diagram (Enterprise Manager)

To copy a table from another database diagram

  1. Connect to the database whose table you want to copy.
  2. Open a database diagram, and click the table that you want to copy to the other database diagram.
  3. Press Ctrl-C.

    This action places the selected table definition on the Clipboard.

  4. Open the database diagram where you want to paste the selection.

    This diagram must be in the same database as the diagram that you are copying from.

  5. Press Ctrl-V.

    The Clipboard contents appear at the new location and remain highlighted until you click elsewhere. If relationships exist between the selected tables and other tables in your diagram, relationship lines are automatically drawn.

When you edit the table in either diagram, your changes are reflected in both diagrams. Similarly, once you save the table in either diagram, the table is no longer considered “modified” in either diagram.

See Also

Copying a Table Across Database Diagrams

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.