How to copy columns from one table to another (Enterprise Manager)

To copy columns from one table to another

1. Expand a server group; then expand a server.
2. Expand Databases, expand the database in which the table belongs, and then click Tables.
3. In the details pane, right-click the table, and then click Design Table for each table involved in the copy operation.
4. Click the columns in the source table to copy
5. Press CTRL-C.

   This action copies the selection from the table and places the column and its current set of properties on the Clipboard.

6. Position the cursor in the other table at the location where you want to insert the columns.
7. Press CRTL-V.

   The column and its properties are inserted at the new location and remain highlighted until you click elsewhere.

8. Run an update query to add the data to the table to which you copied the columns.

See Also