+---------------------------------+
|         MODIFY STRUCTURE        |
+---------------------------------+
MODIFY STRUCTURE

-----------------------------------
Modifies structure of database.
-----------------------------------

MODIFY STRUCTURE opens a dialog for the modification of the database
structure open in the current work area.  If a file is not open in the
current work area, you will be prompted to select a file for
modification.  Editing may then be performed on the structure, including
the addition and deletion of fields, and modification of field names,
sizes and types.  You many also add index tags to a database in the
modify structure dialog.

You may also modify the structure of databases from the Setup... option
of the Database menu popup.

When the structure of a database is modified and the database has a memo
field, the blocksize of the memo file is set to the current blocksize
setting.  The memo file blocksize may be specified with SET BLOCKSIZE.

FoxPro automatically makes a backup copy of the current database prior
to structural modifications.  Once the modifications are complete, the
data contained in the backup .BAK copy of the database file is appended
to the newly modified record structure.  A memo field backup file with a
.TBK extension is also created.

-----------------------------------

See Also:  CREATE, CREATE TABLE - SQL, DISPLAY STRUCTURE

-----------------------------------