REMOVE XMLSCHEMA (Db2 command line processor)

The REMOVE XMLSCHEMA command deletes a previously registered XML schema from the XML schema repository.

Read syntax diagramSkip visual syntax diagram REMOVE XMLSCHEMA relational-identifier
relational-identifier
Specifies a name that is used to refer to the XML schema in relational SQL or XML. This value is the relational identifier that you used when you registered the XML schema.

The relational identifier has the qualifier SYSXSR. If you specify REMOVE XMLSCHEMA with an unqualified relational identifier, you must have previously executed a SET SCHEMA SQL statement to set the schema name to SYSXSR.

Example: Removing an XML schema from the XML schema repository
Suppose that you want to remove an XML schema with relational identifier SYSXSR.PRODSCHEMA from the XML schema repository. Run this command:
REMOVE XMLSCHEMA SYSXSR.PRODSCHEMA