Altova DatabaseSpy 2024 Enterprise Edition

Database Structure Change Script Window

Home Prev Top Next

The Database Structure Change Script window records any changes you make to the database structure in an SQL script. This script is either generated instantly or on demand, depending on the settings in the Change Script options.

ds_identity_column_03

Database Structure Change Script window

In order to provide a better overview if changes are made in large scale, the change script is structured into regions, which can be collapsed or expanded when checking the script. Please note that collapsing a region will not exclude this part of the script from execution; collapsed regions are expanded automatically when the change script is being executed.

 

If you have several data sources connected and you change the structure in more than one of them, a separate tab is created for each data source in the Database Structure Change Script window.

 

When you define primary keys or check constraints, the Database Structure Change Script window also displays comments on the validity of the definition.

The Change Script window showing an invalid Check Contraint definition

The Database Structure Change Script window provides the following commands.

 

Icon

Command

Description

Execute the generated SQL change script

Execute Change Script

Executes the change script and thus implements the recorded changes in the database. In the Change Script options, you can define the time delay during execution of the script.

Stop execution of the Database Structure Change Script

Stop

Terminates the execution of the change script, the remaining changes are not implemented in the database and the Database Structure Change Script window is cleared. This button is only visible while a change script is being executed.

 

Note: When you click the Stop button, all changes that have not been executed so far will be lost.

Generate Change Script

Generate Change Script

Generates or updates, respectively, a change script that reflects all the changes you have made in the database design since the change script has last been updated. This button is only active if you have defined in the Change Script options that the change script be generated on demand.

Edit Change Script

Edit Change Script

Opens the change script in a new SQL Editor window where you can edit it.

 

Note: The script will be removed from the Database Structure Change Script window and the changes will be lost unless you execute the script in the SQL Editor.

Save Change Script

Save Change Script

Opens the standard Windows Save As dialog box where you can save the script as an SQL file.

Discard Changes

Discard Changes

Discards all changes recorded in the change script. The changes you made in the design will not be implemented in the database and the Database Structure Change Script window will be cleared.

 

Note:The Database Structure Change Script window becomes visible whenever you take an action that is about to change the structure of the database, even if you have previously closed this window.

© 2017-2023 Altova GmbH