Metacat

delete from xml_index;

/* removing records from xml_revisions; */

delete from xml_revisions;

/* removing records from xml_documents; */

delete from xml_documents;

/* removing records from xml_nodes; */

delete from xml_nodes;

delete from xml_relation;

commit;