How to move columns without data from one table to another using a database diagram (Enterprise Manager)

To move columns without data from one table to another using a database diagram

1. Open a database diagram.
2. Click the columns that you want to move.
3. Press Ctrl-X.

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

4. Position the cursor in the new table at the location where you want to insert the columns.
5. Press Ctrl-V.

   The columns are inserted at the new location and remain highlighted until you click elsewhere.

See Also