Synchronizing the selected table schema
-
Click Synchronize under the Table Schema List to open the Synchronize Table Schema dialog box, which
synchronizes the selected table schemas with the database. This is only enabled
when a table schema is selected.
If the current connection was opened as read-only, then a message dialog box opens to remind you. Otherwise, a Synchronize Table Schema dialog box opens.
-
Select how to synchronize.
By default, Delete nonexistent columns and Automatically add new columns are cleared.If Delete nonexistent columns is selected, then the IDE compares each column and removes the ones in the schema that no longer exist in the connected database.If Automatically add new columns is selected, then new columns are added into the table schema. By default, the added column is set as visible and the corresponding schema data type is set to String.
-
Click OK to begin the
synchronization according to the settings.
For the Database Data Type and Required column attributes, the IDE compares each column. Then, it updates the ones in the table schema according to the ones in the connected database.
If the selected schemas are nonexistent in the source database, then they are not updated and a message dialog box pops up after synchronization.
If any schema are changed, then the current Database Schema Configurator is marked as modified.
After the synchronization starts, a progress bar is shown in the dialog box status bar to indicate the progress of the synchronization.