Java tutorial
//package com.java2s; /** * Copyright 2016 Alex Yanchenko * * 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. */ import java.util.ArrayList; import android.database.Cursor; import android.database.sqlite.SQLiteDatabase; public class Main { public static ArrayList<String> getTableNames(SQLiteDatabase db) { return readStrings(db, "SELECT name FROM sqlite_master WHERE type='table'", 0); } private static ArrayList<String> readStrings(SQLiteDatabase db, String query, int colIdx) { ArrayList<String> rows = new ArrayList<String>(); Cursor c = db.rawQuery(query, null); while (c.moveToNext()) { rows.add(c.getString(colIdx)); } c.close(); return rows; } }