Vikas Patidar Vikas Patidar - 1 year ago 89
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?

Answer Source

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();
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download