js editor
Web development
Renames a table in the current database.
RENAME TABLE TableName1 TO TableName2 |
Parameters
- TableName1
- Specifies the name of the table to be renamed.
- TableName2
- Specifies the new name of the table.
Remarks
You cannot use RENAME TABLE to change the name of a free table; use RENAME instead.
Example
The following example creates two databases named mydbc1 and mydbc2, and a table named table1. The table is added to mydbc1 when it is created. The table is then closed and removed from mydbc1. ADD TABLE is then used to add the table to mydbc2. RENAME TABLE is used to change the name of the table from table1 to table2.
| В |  Copy Code |
|---|---|
CLOSE DATABASES CREATE DATABASE mydbc1 CREATE DATABASE mydbc2 SET DATABASE TO mydbc1 CREATE TABLE table1 (cField1 C(10), n N(10)) && Adds table to mydbc1 CLOSE TABLES && A table must be closed to remove it from a database REMOVE TABLE table1 SET DATABASE TO mydbc2 ADD TABLE table1 RENAME TABLE table1 TO table2 | |