public static void dropIndex(Connection conn,String schema,String table) throws SQLException {
  init(conn);
  PreparedStatement prep=conn.prepareStatement("DELETE FROM " + SCHEMA + ".INDEXES WHERE SCHEMA=? AND TABLE=?");
  prep.setString(1,schema);
  prep.setString(2,table);
  int rowCount=prep.executeUpdate();
  if (rowCount == 0) {
    return;
  }
  reindex(conn);
}

public static void dropIndex ( Connection conn , String schema , String table ) throws SQLException { init ( conn ) ; PreparedStatement prep = conn . prepareStatement ( "DELETE FROM " + SCHEMA + ".INDEXES WHERE SCHEMA=? AND TABLE=?" ) ; prep . setString ( 1 , schema ) ; prep . setString ( 2 , table ) ; int rowCount = prep . executeUpdate ( ) ; if ( rowCount == 0 ) { return ; } reindex ( conn ) ; }
drop an existing full text index for a table . this method returns silently if no index for this table exists .
