Builds a database DROP INDEX ddl statement for a given table and field. - Android Database

Android examples for Database:Table Index

  1. HOME
  2. Android
  3. Database
  4. Table Index

Description

Builds a database DROP INDEX ddl statement for a given table and field.

Demo Code

/*/*from  w  ww.  ja v a  2  s .c om*/
 * Copyright (C) 2013 The Android Open Source Project
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *      http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License
 */

public class Main{
    /**
     * Builds a DROP INDEX ddl statement for a given table and field.
     *
     * @param table The table name that was originally used to create the index.
     * @param field The field that was originally used to create the index.
     * @return The drop index sql statement.
     */
    @NeededForTesting
    public static String buildDropIndexSql(String table, String field) {
        return "DROP INDEX IF EXISTS " + buildIndexName(table, field);
    }
    /**
     * The index is created with a name using the following convention:
     * <p>
     * [table name]_[field name]_index
     */
    public static String buildIndexName(String table, String field) {
        return table + "_" + field + "_index";
    }
}

Related Tutorials