community.borland.com
Article #28795: Renaming a table
Problem
I have a table in the database named TABLE_ONE. This table contains data.
Is it possible to rename this table to TABLE_TWO? Can I do this via SQL?
Solution
No, you cannot simply rename the table, nor can you rename it using SQL.
You must create a new table with the name you desire and then transfer the
data from TABLE_ONE to TABLE_TWO. This part is fairly straightforward.
The tedious part will be recreating any and all domains, constraints,
triggers, stored procedures, etc, etc. for TABLE_TWO.Last Modified: 25-JUN-02