Exploring and Changing the Database Structure

www.altova.com Print this Topic Previous Page Up One Level Next page

Home > 

Exploring and Changing the Database Structure

Altova website: _ic_link Database editor

 

In addition to writing SQL scripts that create or modify the structure of your database, you can also edit the structure of all your database tables in Design Editor. With Design Editor, you can examine the table structure in detail, add tables or columns to a database, edit their properties, and delete columns or entire tables. In addition, you can also create a primary key, foreign keys, unique keys, as well as indexes and check constraints. You can also rename or delete existing database objects directly from the Online Browser, see Renaming and Deleting Objects.

 

Note:Various limitations apply when editing existing database objects from either the Design Editor or Online Browser, as further mentioned in this documentation. When that is the case, the corresponding commands are disabled, or appropriate notification messages are displayed by DatabaseSpy. The limitations may vary by database kind and driver.

 

Any changes you make to the database structure (either from Online Browser or Design Editor) are not applied immediately but recorded in a change script which is displayed in the Database Structure Change Script window. To actually deploy the changes to the database, you must execute the change script.

dbs_design_editor_zoom80

Design Editor

 

To open a new Design Editor:

Making sure that you have a data source connected, click the Design Editor dbs_ic_design_editor icon in the Standard toolbar, or select the menu option File | New | Design Editor, or press Ctrl+D.

 

If you have more than one data source connected in your project, a new Design Editor window will always be connected to the active data source, that is, the one that is selected in the Online Browser.


© 2019 Altova GmbH