Are you aware that you can simply Use the dbc, and change the relevant records?

>I am having a tough time create a little routine to rename a table in a database. I want to add a TEMP table to a database of the same structure as one of the existing. Then drop the original table and rename the TEMP table into the original.
>
>Here is what I do:
>

>cTblName = "MyTable"
>use (cTblName)
>afields(aDbfStruct)
>set database to MyDatabase
>create table TEMP name TEMP from array aDbfStruct
>close tables
>drop table (cTblName)
>rename table ("TEMP") to (cTblName)
>*-- I was hoping that rename table will rename actual file name
>*-- but it does not. So I have to do this:
>rename ("TEMP.DBF") to (cTblName + ".DBF")
>rename ("TEMP.FPT") to (cTblName + ".FPT")
>

>
>But the table MyTable.DBF is not part of the database after all of that.
>
>What am I missing?
>
>Thank you.