The thing that do me more to anger,
it is that the example of the documentation takes to me in turn.

Doc example:

... RENAME TABLE is used to change the name of the table from table1 to table2.
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

Apply the RENAME TABLE on mydbc1:

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
RENAME TABLE table1 TO table2
REMOVE TABLE table2
SET DATABASE TO mydbc2
* with this the program fail
ADD TABLE table2
* with this the program is ok but you cannot write
... RENAME TABLE is used to change the name of the table from table1 to table2.
ADD TABLE table1

Fabio