Sets an open database as the current database or sets no current database.
SET DATABASE TO [DatabaseName]
- [ DatabaseName]
- Specifies the name of an open database to set as the current database. Omitting DatabaseName or specifying an empty string sets the current database to no database.
SET DATABASE is scoped to the current data session. Though you can have many databases open at the same time, you can set only one as the current database. Commands and functions that operate on a database operate on the current database.
The following example creates two databases named
mydbc2, and a table named
table1. SET DATABASE is used to make
mydbc1 the current database, and
table1 is added to
mydbc1 when it is created. The table is then closed and removed from
mydbc1. SET DATABASE is used to make
mydbc1 the current database, and ADD TABLE is then used to add the table to
mydbc2. RENAME TABLE is used to change the name of the table from
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 REMOVE TABLE table1 SET DATABASE TO mydbc2 ADD TABLE table1 RENAME TABLE table1 TO table2