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