Export (0) Print
Expand All
Expand Minimize

MODIFY DATABASE Command

Visual Studio .NET 2003

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

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

Show:
© 2014 Microsoft