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
.
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