>>>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?
>>
>>Short of dropping the table from the .DBC, renaming it as a free table, and then readding it, rebuilding any views and relations using the new name, no. Stonefield Database Toolkit handles this neatly, but it's not free...
>
>See my post, the method works very well. But I should have added that making a backup, especially when you're first trying that method, is not a terrible idea :) Also you'll want to go into the table properties and update the DBC name, as well, to be in sync with the file name...
Thanks, but I'm an SDT sort-of-guy, and it's a whole lot easier!