Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server
Azure SQL Database
Azure SQL Managed Instance
Analytics Platform System (PDW)
You can copy a table from one database diagram to another in the same database.
Copying a table from one database diagram to another diagram adds a reference to the table in the second diagram. The table isn't duplicated in your database. For example, if you copy the authors table from one database diagram to another, each diagram references the same authors table in the database.
Copy a table from another database diagram
Make sure you're connected to the database whose table you want to copy.
Open the source and target database diagrams and within the source diagram, select the table that you want to copy to the target diagram.
Select the Copy button on the toolbar. This action places the selected table definition on the Clipboard.
Switch to the target diagram. This diagram must be in the same database as the source diagram.
Select the Paste button on the toolbar. The Clipboard contents appear at the new location and remain highlighted until you select elsewhere. If relationships exist between the selected tables and other tables in the target 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.