class DBQueries {

    public static void dropIndexOnTable(final String tableName, final Connection connection){
        final String sqlDropIndex = String.format("DROP INDEX IF EXISTS cqidx_%s_value;",tableName);
        Statement statement = null;

        try {
            statement = connection.createStatement();
            statement.executeUpdate(sqlDropIndex);
        }catch (SQLException e){
            throw new IllegalStateException("Unable to drop index on table: " + tableName, e);
        }finally {
            DBUtils.closeQuietly(statement);
        }
    }

}