Altova DatabaseSpy 2024 Professional Edition

Managing XML Schemas

Home Prev Top Next

To view, add, or drop XML schemas in a database, DatabaseSpy provides the XML Schema management for databases dialog box. To open this dialog box, do one of the following:


Click the XML Schema Management ic_xml-schema toolbar button.

Select the menu command Tools | XML Schema Management for Databases.

Right-click an XML schema in the Online Browser and choose Manage XML Schemas... from the context menu.


If you are not connected to a data source, the dialog box appears in offline state. To connect to a database, click the Connect to a database dbs_ic_quick_connect button and follow the wizard steps. On successful connection to a database that supports XML, the list of available XML schemas appears in the dialog box, for example:


You can now add schemas, drop schemas, or view a schema in XMLSpy by clicking the corresponding buttons. You can also edit a schema's description (and "Decomposition" property if applicable) directly from the grid.


Note that any changes you make on the dialog box are not immediately committed to the database. Edited objects are marked as new (ic_new), changed (ic_changed), or deleted (ic_delete) in the grid. You must click Commit changes in order for the changes to become effective. To undo the deletion of a schema while the change is not committed, first select the schema and then click dbs_ic_remove_drop_flag Remove Drop Flag .


Commit changes

Sends an SQL transaction to the database to make the changes on the dialog box permanent. This button is disabled if no changes have been made yet.


Closes the dialog box. If there are uncommitted changes, a message box asks for your confirmation to commit or discard them.

ic_new Add Schema

Opens a dialog box where you can select a new XML schema to be registered with the database. If the schema has references to other schemas, these will be registered as well.

ic_delete Drop Schema

Marks the schema for deletion. The actual deletion occurs only after you click Commit changes.

dbs_ic_remove_drop_flag Remove Drop Flag

Undoes the deletion of the schema. This button is enabled only for schemas that have been marked for deletion.

dbs_ic_xmlschema_view View Schema

Opens the XML schema (for viewing) in Altova XMLSpy. Note that any schema changes made from XMLSpy are saved locally and do not affect the database.


To display additional information about the schema, select the Show details check box. To resize the dialog box, click and drag its lower-right corner outwards.


After you click Commit changes, the outcome of the SQL transaction is reported in the Report tab.


Your database user account must have the relevant database rights in order to add or drop XML schemas; otherwise, the SQL transaction fails with an error.


All the functions in this dialog box are also available as a context menu when you right-click anywhere in the data grid.

© 2018-2024 Altova GmbH