SET DATABASE Command
Specifies the current database.
SET DATABASE TO [DatabaseName]
- Specifies the name of an open database to be made the current database. If you omit DatabaseName, no open database is made the current database.
Many databases can be open at the same time, but only one can be the current database. Commands and functions that manipulate open databases, such as ADD TABLE and DBC( ), operate on the current database.
The current database can also be specified by choosing an open database from the Database drop-down list on the Standard toolbar.
Visual FoxPro may automatically open databases when a query or a Form is executed.
SET DATABASE is scoped to the current data session.
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 && 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