How many tables and databases can I create in Android sqlite?

Question

How many databases can I create in one instance of sqlite?

In one Database how many tables can I create in sqlite?

What is the maximum size of data that a Table or column can hold?

Answer 1

How many databases can i create in one application?

As many as you want, within the limits of available disk space.

in one Database how many tables can i create?

A billion or so, though you will run out of disk space first.

and what was the maximum size of data that can holds a Table or a column?

For Android, as much disk space as you have available.

See: http://sqlite.org/limits.html

Answer 2

you can create multiple database, tables in your application and the size of database is depends on your sd-card size because SQLite database stores in Environment.getDataDirectory() + /data/<Package Name>/databases.

you can check the size of database by using this code

SQLiteDatabase db;

// ...

long size = new File(db.getPath()).length();