It is not problem to rename table in the database designer.
I needed to rename big numbers of tables due to some criteria.
So I tryed to do this by code, not in the database designer
First I did
1 rename table oldtable to newtable
The result was name was changed only in the database, but file name was old
2 rename table oldtable to newtable
rename oldtable.dbf to newtable.dbf
rename oldtable.cdx to newtable.cdx
I changed files names, but attempt to modify table in the designer gave error , it is not possible to find table at the path, locate or delete
3 rename oldtable.dbf to newtable.dbf
rename oldtable.cdx to newtable.cdx
rename table oldtable to newtable
It also did not give good result.
What code lines do emulate changing table in the database designer
Thanks in advance, Vladimir.
MVP-2006-2011, PHD in Math and Physics ,
host of
www.foxclub.ru,
VFP lector at Interface and Microinform companies
Head science researcher of VNIIA Rosatom.