Reading SMS and MMS Database in Android

android database sms mms
user1894963 picture user1894963 · Dec 30, 2012 · Viewed 14.1k times · Source

Google is providing a very nice documentation of the contacts provider in Android API. (You can see it HERE. It has a full details of all tables and columns names used in these databases. I tried to look for the same for sms and mms databases (which are located in mmssms.db) but I could not see any documentation for that. So my questions are:

  • First, is it true that there is no such documentation ?
  • If yes, why google tried to keep this away from us ?
  • And, in your opinion, how can I get more details about the tables used and a description of each column in that table (i.e. what each column is used for).

By the way, I need this information to write a java program that will read sms/mms data. You can assume that I already got mmssms.db file.

Thanks, and I appreciate any help.

Answer

Sreejith Krishnan R picture Sreejith Krishnan R · Dec 30, 2012

  1. There is no official documentation about sms and mms database in android

  2. ............

  3. You can get a lot of information about what each column is used for from the Telephony.java. You can get the file here. Telephony.java

Related questions

How do I view the SQLite database on an Android device?

I have a set of data in an SQLite database. I need to view the database on a device. How do I do that? I have checked in ddms mode. The data in file explorer is empty.

Read More
What are the best practices for SQLite on Android?

What would be considered the best practices when executing queries on an SQLite database within an Android app? Is it safe to run inserts, deletes and select queries from an AsyncTask's doInBackground? Or should I use the UI Thread? I …

Read More
Best way to work with dates in Android SQLite

I'm having some trouble working with dates on my Android application that uses SQLite. I have a couple questions: What type should I use to store dates in SQLite (text, integer, ...)? Given the best way to store dates how do …

Read More