Cutting, copying, and pasting columns
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. To an
existing table, you can only append a column. 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.