How to use

dropIndex

method

in

org.tmatesoft.sqljet.core.table.SqlJetDb

private void handleDropIndex() throws SqlJetException {
  CommonTree options = (CommonTree) ast.getChild(0);
  boolean ifExists = options.getChildCount() > 0 && "exists".equalsIgnoreCase(options.getChild(0).getText());
  String indexName = ast.getChild(1).getText();
  if (db.getSchema().getIndex(indexName) != null) {
    db.dropIndex(indexName);
  } else if (!ifExists) {
    throw new SqlJetException(SqlJetErrorCode.ERROR, "Index does not exists.");
  }
}

} else {    
  if (sDb.getDb().getSchema().getIndex("I_ACTUAL_CHANGELIST") != null) {
    sDb.getDb().dropIndex("I_ACTUAL_CHANGELIST");
    sDb.getDb().dropIndex("I_EXTERNALS_PARENT");
  sDb.getDb().dropIndex("I_NODES_PARENT");
  sDb.getDb().createIndex("CREATE UNIQUE INDEX I_NODES_PARENT ON NODES (wc_id, parent_relpath, local_relpath, op_depth);");
  sDb.getDb().dropIndex("I_ACTUAL_PARENT");
  sDb.getDb().createIndex("CREATE UNIQUE INDEX I_ACTUAL_PARENT ON ACTUAL_NODE (wc_id, parent_relpath, local_relpath);");

if (stmt.isDrop()) {
  if (db.getSchema().getIndexNames().contains(stmt.getName())) {
    db.dropIndex(stmt.getSql());
      db.dropIndex(stmt.getName());