How do I retrieve all the tables from database? (Android, SQLite) [duplicate]

Question

Possible Duplicate:
How do I list the tables in a SQLite database file

I am trying to make a simple interface for creating a simple database using Android device. For example, a program for inserting my home collection of movies into database. Maybe I am wrong from the start, but this is my try:

Here I retrieve data from fields and insert them into a new table.

        EditText title = (EditText)findViewById(R.id.Title); 
        String Title = title.getText().toString();

        EditText d = (EditText)findViewById(R.id.director); 
        String Director = d.getText().toString();

                SQLiteDatabase db = openOrCreateDatabase("Films", MODE_PRIVATE, null);
        db.execSQL("CREATE TABLE IF NOT EXISTS " + Title + " (Title VARCHAR, Director VARCHAR);");
        db.execSQL("INSERT INTO " + Title + "(Title) VALUES('" + Title + "');");
        db.execSQL("INSERT INTO " + Title + " (Director) VALUES('" + Director + "');");
        db.close();

So for each new Title I create a new table. But then I need all of these tables to print them in a new Activity as a list or something like that. But I don't know how to get all the tables from database.

I found the command:

SQLiteDatabase db = openOrCreateDatabase("Films", MODE_PRIVATE, null);
Cursor c = db.rawQuery("SELECT * FROM tablename", null);

But it works only for one table if I know its name, and what I need is to get all the tables and the data from them.

Could you help me please?

Barak · Accepted Answer · 2012-05-13 13:53:18Z

2

Run a query using this:

Cursor c = db.rawQuery("SELECT * FROM films.sqlite_master WHERE type='table'",null);

EDIT

I forgot that this was Android and rawQuery already has the table name. This should work:

Cursor c = db.rawQuery("SELECT * FROM sqlite_master WHERE type='table'",null);

edited May 13, 2012 at 13:53

answered May 13, 2012 at 13:34

Barak

16.4k9 gold badges54 silver badges86 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

zeliboba_fett Over a year ago

Oh, I tried this, but DDMS says "No such table films.sqlite_master", so he thinks it's table name films.sqlite_master.

Barak Over a year ago

Ok, try "SELECT * FROM sqlite_master WHERE type='table'" instead. I forgot that we were talking android specifically.

zeliboba_fett Over a year ago

Thank you very much! Now I'll be thinking of how to sort these tables and how to work with them.

zeliboba_fett Over a year ago

So now I selected all the tables, but they all have similar columns, so what's the way I'm gonna retrieve the data from them?

Imran Rana Over a year ago

Manually go through each table with a SELECT or similar to look at the rows. Reference

|

Collectives™ on Stack Overflow

How do I retrieve all the tables from database? (Android, SQLite) [duplicate]

1 Answer 1

6 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Linked

Related