You can use the DELETE statement to remove one or more rows from an Object File System table. See SQL Data Manipulation Language for details of syntax and usages of the DELETE statement.
For an Object File System table, a DELETE statement removes rows based on the qualification criteria.
When a row or a set of rows are deleted from Object File System table, data objects that were holding the deleted rows are rebuilt with remaining rows. All kinds of DELETE operations, such as whole table delete (DELETE ALL), partial delete (DELETE with WHERE condition involving target table), and join delete are supported.
During the DELETE statement process, deleted data (and leaf) objects are not physically removed from external object storage, but logged separately for a future purge activity. These objects are eligible for removal at the end of their retention period. A background task eventually removes obsolete objects. In case of DELETE ALL, a new empty root object is created with old root added to delete index.