Perform the following steps to modify an SQL database:
-
From the tree view, expand the server containing the database you want to modify.
Note: If the database is not yet open, click Open Database to open the database for modification. -
Right-click the database and click Modify SQL Database.
The Modify SQL Database dialog box appears.
-
In the DDL File Name box, click Browse, navigate to the database definition language file, and then select the file.
The path and file name appear in the DDL File Name box.
Note: You can also type the location and name of the DDL file in the DDL File Name box. -
Click Modify.
The Modify Database Status message box appears indicating that the changes are complete.
Note: The modification process closed the database. -
Click OK.
-
From the tree view, right-click the database and click Open Database.
The Open Database dialog box appears.
-
Log in with the appropriate credentials and click OK.
A message appears indicating that the database has been opened.
-
Continue with your work.
