Vikas Patidar Vikas Patidar - 4 months ago 12x
Android Question

How many database columns associated with a SMS in android?

I want to read all the messages and their respective details from my phone.
For this I am using the Uri like this:

Uri sms = Uri.parse("content://sms/");

But I don't know how many columns in database which are associated with this uri.

I want to display the following information:

  1. Message Type

  2. Sender Number

  3. Message Body

  4. Timestamp

Please can anybody enumerate the total column names?


You should be able to rotate through the Cursor and look for yourself:

mCursor = managedQuery(sms, null, null, null, null);

StringBuffer info = new StringBuffer();
for( int i = 0; i < mCursor.getColumnCount(); i++) {
    info.append("Column: " + mCursor.getColumnName(i) + "\n");
Toast.makeText(getApplicationContext(), info.toString(), Toast.LENGTH_LONG).show();