Deleting XML Schemas

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

Home >  XML Schema Management >

Deleting XML Schemas

The XML Schema management for databases dialog box can also be used to remove an XML schema from a database. Upon clicking the Drop Schema button, the schema is marked for deletion (ic_delete) in the list box and you have to confirm the deletion before the schema is actually dropped from the database's XSR repository.

dlg_manage-schemas-drop

The XML Schema management for databases dialog box also provides a Remove Drop Flag button that allows you to undo the deletion, provided that the changes have not been committed yet.

 

Alternatively, you can also use an option in the context menu of the Online Browser to delete XML schemas from the database. The XML schema is marked for deletion in the Online Browser and a database structure change script is generated which must be executed to commit the deletion to the database.

 

Note:If you delete an XML schema from the XML Schemas sub-folder of a database column (i.e., from the sub-folder that shows the XML schemas assigned to a certain column of a database table), the XML schema will be deleted from the database's XSR repository and not just removed from the column.

 

 

To delete a registered XML schema from the database:

1.In the XML Schema management for databases dialog box, select a database connection from the left drop-down list if no data source connection is active.
2.Select the XML schema you want to delete and click the Drop Schema button. The XML schema is marked for deletion (ic_delete) in the list box. Alternatively, you can also right-click the schema and select Drop Schema from the context menu.
3.Click the Commit changes button.
4.Click the Close button 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.In the Online Browser, right-click the XML schema you want to delete and select Delete from the context menu. Alternatively, you can also select the XML schema and press the Delete key. A change script is generated in the Database Structure Change Script window and the XML schema is marked for deletion ic_drop-XSD in the Online Browser.
2.In the Database Structure Change Script window, click the Execute Change Script ic_execute-sql button.

 

 

To undo the deletion of an XML schema:

1.In the XML Schema management for databases dialog box, select an XML schema that is marked for deletion.
2.Click the Remove Drop Flag button or select the option Remove Drop Flag from the context menu.
3.Click the Close button. A prompt appears, asking you whether you would like to commit or discard the changes.
4.Click Yes.

© 2019 Altova GmbH