>ALTER TABLE [RENAME COLUMN FieldName4 TO FieldName5]
>
>ALTER TABLE can be used to modify the structure of a table that has not been added to a database. However, Visual FoxPro generates an error if you include the DEFAULT, FOREIGN KEY, PRIMARY KEY, REFERENCES, or SET clauses when modifying a free table.

John -

Just to clarify:
It can be used on tables in a database or free tables.

In addition, it will generate an error - on either type of table - if the field you are renaming is part of an index.