>> use yourTable
>> copy to yourpath\yournewtable.dbf database yourDATABASE with CDX

Thanks to you and others for alterting me to the DATABASE parameter in VFP's COPY TO command (guess I should read the manual someday). In this case I only wanted to change what database the table was in, not move or rename it, so I COPY TO'd it to the same folder WITH PRODUCTION and the new DATABASE name, deleted the original, opened the new database and did a RENAME TABLE to rename the copy back to the orginal's name. There's probably an easier way but this one seemed to work.