MODIFY DATABASE Command
Opens the Database Designer, making it possible for you to interactively modify the current database.
MODIFY DATABASE [DatabaseName | ?] [NOWAIT] [NOEDIT]
- Specifies the name of the database to modify.
- Displays the Open dialog box from which you can specify the name of the database to modify.
- Continues program execution after the Database Designer is opened. The program doesn't wait for the Database Designer to be closed, but continues execution on the program line immediately following the line that contains MODIFY DATABASE NOWAIT. If you omit NOWAIT when MODIFY DATABASE is issued in a program, the Database Designer is opened and program execution pauses until the Database Designer is closed.
NOWAIT is effective only from within a program. It has no effect on MODIFY DATABASE when issued from the Command window.
- Prevents changes to the database.
The following example displays the Database Designer with the tables in the
CLOSE DATABASES SET PATH TO (HOME(2) + 'data\') && Sets path to database MODIFY DATABASE testdata && Open testdata database
ADD TABLE | CLOSE DATABASES | CREATE DATABASE | DBC( ) | DBGETPROP( ) | DBSETPROP( ) | DELETE DATABASE | DISPLAY TABLES | OPEN DATABASE | REMOVE TABLE | Database Designer | Adding Tables to a Database