Editing Relational Tables › Edit the Structure of a New Table › Line Commands for Editing Table Structure

Line Commands for Editing Table Structure

To edit column definitions for a new table, enter these commands in the line number field, on the line you want to edit:

A

Places the copied or moved data in the table after this column.

B

Places the copied or moved data in the table before this column.

C

Copies this column definition.

CC

Uses this command to select a range of columns for copying. Enter CC beside the first line and the last line of the range.

D

Deletes this column.

DD

Uses this command to select a range of columns to delete. Enter DD beside the first line and the last line of the range.

I

Inserts a column.

M

Moves this column.

MM

Uses this command to select a range of columns to move. Enter MM beside the first line and the last line of the range.

R

Repeats this column.

RR

Uses this command to select a range of columns to repeat. Enter RR beside the first line and the last line of the range.

TJnnnn

Uses this command to join text, shift it to the left, delete a word, or delete text to the right of the cursor.

TSnnnn

Uses this command to split text or to shift it to the right.

To begin editing a new table, issue I line commands to insert columns and type in the required data for each column. After you have inserted some columns, you can issue other line commands to manipulate those columns (for example, to copy or move columns).