Assign columns /text/sdatabase/05030400.xhp Sun Microsystems, Inc.

Assign columns

In the data source explorer, you can copy a table by dragging and dropping the table onto the table container. If you select the Attach data check box on the first page of the Copy table dialog, the Assign columns dialog opens as the second window. You can use this dialog to map the contents of a data field in the source table to a different data field in the destination table.

Source table

Lists the data fields in the source table. To include a data field from the source table in the destination table, select the check box in front of the data field name. To map the contents of a data field in the source table to a different data field in the destination table, click the data field in the source table list, and then click the up or down arrow. To include all of the source data fields in the destination table, click All.

Destination table

Lists the possible data fields in the destination table. Only the data fields that are selected in the source table list will be included the destination table.

up

Moves the selected entry up one position in the list.

down

Moves the selected entry down one position in the list.

all

Selects all of the data fields in the list.

none

Clears all of the check boxes in the list.