How to copy columns from one table to another using a database diagram (Enterprise Manager)
To copy columns from one table to another using a database diagram
- Open a database diagram.
- Click the columns that you want to move.
- Press Ctrl-C.
This action places the selection with its current set of properties on the Clipboard.
- Position the cursor in the new table at the location where you want to insert the columns.
- Press Ctrl-V.
The columns are inserted at the new location and remain highlighted until you click elsewhere.
- Run an update query to add the data to the table to which you copied the columns.
- Return to the database diagram and delete the columns from the original table.
See Also
(c) 1988-98 Microsoft Corporation. All Rights Reserved.