DatabaseSpy allows you to change certain parameters of XML schemas that are registered with the database. You may have to activate the Show details check box in the XML Schema management for databases dialog box to see all the properties.
When you add a new XML schema to the database, you can edit the schema name and the location information in the XML Schema management for databases dialog box before you commit the new schema to the database.
Once an XML schema has been registered with the database, only the schema description and the decomposition property can be changed. This can be done either in the XML Schema management for databases dialog box or in the Properties window.
Although you can edit an XML schema that you have opened for viewing in XMLSpy, you cannot save back a schema to the database. Any changes you make in XMLSpy must be saved in a new XML schema file.
To change XML schema properties:
1.Select the menu option Tools | XML Schema Management for Databases or click the XML Schema Management icon in the Tools toolbar, or right-click an XML schema in the Online Browser and choose Manage XML Schemas... from the context menu.
2.In the XML Schema management for databases dialog box, select an XML schema in the list box.
3.Optionally, activate the Show details check box if the Namespace, Decomp., and Description columns are not displayed.
4.If applicable, change the status of the Decomp. check box as required. The XML schema is enabled for decomposition if the decomposition property is checked.
5.If applicable, change the database schema in the DB schema column as required.
6.Edit the schema description as required.
7.Click the Commit changes button to confirm your changes.
8.Click Close to exit the dialog box. If any changes have not been committed yet, a prompt appears, asking you whether you would like to commit or discard the changes.
Alternatively, do the following:
1.Select an XML schema in the Online Browser and edit the properties in the properties window.
2.Execute the change script to commit your changes to the database.