In the Database painter, you can use the Cut, Copy, and Paste buttons in the PainterBar (or Cut, Copy, and Paste from the Edit or pop-up menu) to cut, copy, and paste one column at a time within a table or between tables.
To cut or copy a column within a table:
Put the insertion point anywhere in the column you want to cut or copy.
Click the Cut or Copy button in the PainterBar.
To paste a column within a table:
Put the insertion point in the column you want to paste to.
If you are changing an existing table, put the insertion point in the last column of the table. If you try to insert a column between two columns, you get an error message. You can append a column only to an existing table. If you are defining a new table, you can paste a column anywhere.
Click the Paste button in the PainterBar.
To paste a column to a different table:
Open another instance of the Columns view and use Alter Table to display an existing table or click New to create a new table.
Put the insertion point in the column you want to paste to.
Click the Paste button in the PainterBar.
