JChem provides the chemaxon.jchem.db.UpdateHandler class for updating and inserting rows in structure tables. A structure table contains fixed columns (
cd_...) and, optionally, additional columns that have been defined explicitly.
The deleteRows method of the UpdateHandler class is suggested for deleting rows from structure tables. It also increments
updateCounter for the given table in
JChemProperties, which is important when caching is used during structure search.
Other useful methods of UpdateHandler:
Retrieves the name of all structure tables.
Creates a structure table.
Removes a structure table.