Please enable JavaScript to view this site.

Altova DatabaseSpy 2020 Enterprise Edition

» No topics above this level «

XML Schema Management

Scroll Home Prev Top Next More

If the database supports XML as type, you can load XML instance files into database fields, and save them to local files from the database fields (see Editing XML Columns ).


XML support is available for the following databases: IBM DB2 9.1 and later, SQL Server, Oracle, PostgreSQL 8.3 and later.


Note:PostgreSQL does not have XML schema management (add schema, drop schema).


If XML schema management is supported by the database, you can register XML schemas with the database. The XML schemas are displayed in the Online Browser in a sub-folder called XML Schemas.


Click the expand button in front of an XML schema name to view dependent/secondary schemas. The properties of the individual XML schemas can be viewed and—where possible—edited in the Properties window.


To view an XML schema in detail, you can open it in XMLSpy. For this purpose, a context menu option in the Online Browser as well as a button in the XML Schema management for databases dialog box are available. You must have XMLSpy installed on you PC to be able to use this feature.


Viewing XML schemas assigned to a particular column

All the XML schemas that have been assigned to an XML data cell of a table are displayed in the Online Browser in an XML Schemas sub-folder below the respective column. This way, you can see at a glance which XML schemas are used to validate the content of a particular XML column in the database.


To view an XML schema in XMLSpy:

Do one of the following:


In the Online Browser, right-click a schema in the XML Schemas folder and select View in XMLSpy from the context menu.

In the XML Schema management for databases dialog box, select a schema and click the View Schema button, or right-click the schema and choose View Schema from the context menu.

© 2020 Altova GmbH