Table designer

Related topics

Use the Table designer to design or restructure a table. If you're creating a new table,

1. Set the table type in the Inspector. You can select a BDE-standard table type or the table types of those databases for which you have created BDE aliases.

• In the Table design surface, type a name in the Name field. (You have to name a field before you can specify any of its other characteristics.)

• Specify values for the remaining attributes (Type, Width, Decimal, Index) by typing what you want, or by selecting a value from the drop-down list, or by clicking the spinbox arrows. You can tab through these to select the default values.

• To create additional fields, press Return when you have finished specifying a field. Or press the Down arrow key. Or right-click and choose Add Field from the context menu.

Inserting and deleting fields

To insert a field between others or delete a field, right-click in the Table designer window, and choose the appropriate command from the context menu.

Reordering a field

To reorder the sequence of fields, place the insertion point in the field number box—it becomes a hand—and move the field to the desired position in the list.

Warning:

Later on in your work, do not use functions such as CHR( ), LTRIM( ), RTRIM( ), TRIM( ), or IIF( ) that vary the field width in the key expression.