What is a maximum size of SQLite database on Android?

by

Maximum length of a string or BLOB Default size is 1 GB Max size is 2.147483647

Maximum Number Of Columns Default size is 2000 Max size is 32767

Maximum Length Of An SQL Statement Default size is 1 MB Max size is 1.073741824

Maximum Number Of Tables In A Join Default is 64 tables

Maximum Number Of Attached Databases Default is 10 Max size is 125

Maximum Number Of Rows In A Table Max Size is 18446744073.709552765

Maximum Database Size 140 tb but it will depends on your device disk size.

More Related Contents:

  1. get Feature item to list View
  2. When does SQLiteOpenHelper onCreate() / onUpgrade() run?
  3. How to store image in SQLite database
  4. How do I use prepared statements in SQlite in Android?
  5. Where does Android emulator store SQLite database?
  6. Android SQLite Example [closed]
  7. Android database encryption
  8. Android SQLite issue – table … has no column named
  9. How to add new Column to Android SQLite Database?
  10. Android error – close() was never explicitly called on database
  11. Exporting SQLite Database to csv file in android
  12. Android SQLite Database, WHY drop table and recreate on upgrade
  13. How to get Last record from Sqlite?
  14. Android ExpandableListView and SQLite Database
  15. Multiple Table SQLite DB Adapter(s) in Android?
  16. select distinct value in android sqlite
  17. A pre-populated database does not work at API 28 throws “no such table” exception
  18. Closing the database in a ContentProvider
  19. Android SDK Manager gives “Failed to fetch URL https://dl-ssl.google.com/android/repository/repository.xml” error when selecting repository
  20. Get last inserted value from sqlite database Android
  21. Could not allocate CursorWindow
  22. When should I do certain SQLite operations on another thread(not the main thread)?
  23. Changing values from Cursor using SimpleCursorAdapter
  24. SQLite exception: Database is locked issue
  25. How can I reset a autoincrement sequence number in sqlite
  26. Sqlite issues with HTC Desire HD
  27. SQLiteOpenHelper – creating database on SD card
  28. difference between rawquery and execSQL in android sqlite database
  29. Get SQLite database from Android app
  30. When to close db connection on android? Every time after your operation finished or after your app exit

Leave a Comment