Copying a table from one database diagram to another diagram adds a reference to the table in the second diagram. The table is not duplicated in developers’ database. For example, if they copy the clients table from one database diagram to another, each diagram references the same clients table in the database. When Developers working with SQL Server “Denali”, MS SQL Server 2008 R2 and MS SQL Server 2005 want to copy a table from another database diagram, they should follow the next steps:
1. Make sure they are connected to the database whose table they want to copy.
2. Open the source and target database diagrams and within the source diagram, select the table that they want to copy to the target diagram.
3. Click the Copy button on the toolbar. This action places the selected table definition on the Clipboard.
4. Switch to the target diagram. This diagram must be in the same database as the source diagram.
5. Click the Paste button on the toolbar. The Clipboard contents appear at the new location and remain highlighted until they click elsewhere. If relationships exist between the selected tables and other tables in the target diagram, relationship lines are automatically drawn.
When developers edit the table in either diagram, their changes are reflected in both diagrams.