>What is the way to rename a table in a database with both names changed, the longname and the file name?
There's a slightly messy way that works. You can use the combination of:
RENAME TABLE oldtable TO newtable
RENAME oldtable.dbf TO newtable.dbf
If needed, also do these:
RENAME oldtable.fpt TO newtable.fpt
RENAME oldtable.cdx TO newtable.cdx
VALI DATA RECO
Then point the DBC to the new tablename when it asks to locate it.
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.