Altering a Table

To alter a table:

1. Open the project for which you must perform an alter.

2. From the Build menu, select the appropriate scope of your build.

   The Build dialog box appears.

3. Select the Alter Tables option in the Build Options group box.

   Selecting the Alter Tables option automatically selects and disables the Create Indexes and Create Trigger (only if triggers are needed) option. In the Build Execute Options group box, only the Build script file option is enabled.

4. Click the Settings button in the Build dialog box to set user-defined defaults.

   Select the appropriate alter, logging, and scripts settings.

   Note:

   The alter process takes care of the indexes, regardless of the Alter Table Options you select on the Alter tab of the Build Settings dialog box. In the case of the Alter by Table Rename option, the indexes are dropped automatically when the temporary table is dropped. For the Alter in Place option, the index creation process goes through the Recreate index only if modified option on the Create tab.

5. In the Build dialog box, click Build to run the Alter Tables process.

   The length of a build process depends on the number of definitions that require building. Watch the Build Progress dialog box to monitor the Build process. When the process completes, check any errors listed in the log file.