>I'm trying to rename a table in a database. The RENAME TABLE command only modifies the alias in the database, but does not rename the file(s) on disk.
>
>The RENAME command does not work, and in fact creates an error.
>
>Does anyone know how to do this gracefully?
>
>Thanks.
>
>Bob Bartel
>MarketWare

Bob,

I'm not quit sure about whow rename works, but you may try a statement like

select * from mytable into DATABASE mydatabase NAME mynewtable and then delete the old one. Have a look a select sql in the help file.