Manage XML Schemas

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

Home >  User Guide and Reference > Menu Commands > DB Menu > SQL Server >

Manage XML Schemas

XML Schema management for databases enables you to add and delete XML Schemas from the schema repository of an XML database. After connecting to the database, XMLSpy provides the XML Schema Management for Databases dialog, in which XML Schemas can be managed.

DBManageXMLSchemas

The dialog box provides a Quick Connect ic_quickconnect icon which calls the Quick Connect wizard to connect to a data source. If more than one connection currently exists, the required connection can be selected from the combo box on the to left-hand side. The required root object can then be selected from the right-hand side combo box. All the XML Schemas currently in the repository for that root object are displayed in the dialog box. The name, location, and namespace of each schema are listed, as well as the option for decomposition..

Note that the stored schemas can also be viewed in the Database Query window (screenshot below), but they cannot be managed there. To manage schemas, use the XML Schema Management for Databases dialog.

DQueryXMLSchemas

In the XML Schema Management dialog you can do the following:

 

Add a schema using the Add Schema button. The selected schema will be appended to the list and marked for addition.
Mark schemas in the list for deletion with the Drop Schema button. The Drop flag can be removed with the Remove Drop Flag button.
Open a selected schema in Schema View by clicking the View Schema button.
Commit the addition and drop (deletion) changes with the Commit Changes button.

 

After changes have been committed, a report of the commit action can be viewed in the Report tab (screenshot below).

DBXMLSchemaReports

 

 


© 2019 Altova GmbH