Database Structure Change Script Window
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.
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 Database Structure Change Script window provides the following commands.
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.
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
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
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
Opens the standard Windows Save As dialog box where you can save the script as an SQL file.
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.|