Moving Columns from One Table to Another
You can move columns from one table to another table in the same database diagram or in a different diagram. Moving columns in the database diagram moves the column definition only. The data itself is not automatically transferred to the second table as part of this process.
Tip To move both the column's definition and its data, you can use the Query Designer in conjunction with the Database Designer. For information about the Query Designer, see Designing Queries.
To move columns without data from one table to another
In your database diagram, select the columns that you want to move.
Click the Cut button on the toolbar. This action deletes the selection from the table and places the column and 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.
Click the Paste button on the toolbar. The columns are inserted at the new location and remain highlighted until you click elsewhere.
To move columns with data from one table to another
In your database diagram, select the columns that you want to move.
Click the Copy button on the toolbar. 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.
Click the Paste button on the toolbar. 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. For details, see Creating Update Queries.
Return to the database diagram and delete the columns from the original table. For details, see Deleting Columns from a Table.