Share via


MODIFY DATABASE Command

Opens the Database Designer, making it possible for you to interactively modify the current database.

MODIFY DATABASE [DatabaseName | ?] [NOWAIT] [NOEDIT]

Parameters

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

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

  • NOEDIT
    Prevents changes to the database.

Remarks

MODIFY DATABASE fires the dbc_Activate Event. For more information about interactively modifying a database with the Database Designer, see the Database Designer and Adding Tables to a Database.

Example

The following example displays the Database Designer with the tables in the testdata database.

CLOSE DATABASES
SET PATH TO (HOME(2) + 'data\')     && Sets path to database
MODIFY DATABASE testdata  && Open testdata database

See Also

ADD TABLE | CLOSE DATABASES | CREATE DATABASE | DBC( ) | DBGETPROP( ) | DBSETPROP( ) | DELETE DATABASE | DISPLAY TABLES | OPEN DATABASE | REMOVE TABLE | Database Designer | Adding Tables to a Database