Opens the current database in the Database Designer so you can visually modify the database.
MODIFY DATABASE [DatabaseName | ?] [NOWAIT] [NOEDIT]
- [DatabaseName | ?]
- Specifies the name of the database to modify or displays the Open dialog box so you can browse for and select a database.
Continues program execution after the Database Designer opens.
The program does not wait for the Database Designer to close but continues execution on the program line immediately following the line that contains MODIFY DATABASE NOWAIT. Omitting NOWAIT pauses program execution until the Database Designer closes.
Note: NOWAIT is valid only from within a program. When included with MODIFY DATABASE in the Command window, NOWAIT has no effect.
- Prevents changes to the database.
Calling MODIFY DATABASE triggers the dbc_Activate event. For more information, see dbc_Activate Event.
The following example closes all open databases, sets a path to the Visual FoxPro ..\Samples\Northwind directory, and opens the Northwind sample database in the Database Designer:
CLOSE DATABASES SET PATH TO (HOME(2) + 'Northwind\') MODIFY DATABASE Northwind