How many database columns associated with a SMS in android?

Question

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:

Message Type
Sender Number
Message Body
Timestamp

Please can anybody enumerate the total column names?

score 53 · Accepted Answer · answered Oct 26 '10 at 12:42

package com.readsms;

import android.app.Activity;
import android.content.ContentResolver;
import android.database.Cursor;
import android.net.Uri;
import android.os.Bundle;
import android.util.Log;

public class ReadSMS extends Activity 
{
    private static final String tag = "Whozzat";

    @Override
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.main);

        Uri sms = Uri.parse("content://sms/inbox");
        ContentResolver cr = this.getContentResolver();
        Cursor c = cr.query(sms, null, null, null, null);
        for (int i = 0; i < c.getColumnCount(); i++)
        {
            Log.v(tag, c.getColumnName(i).toString());
        }
        c.close();
    }
}

after running this code snippet I have got the following columns:

alt text

score 25 · Answer 2 · answered Oct 26 '10 at 10:29

25

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();

answered Oct 26 '10 at 10:29

Dennis Winter

2,027
4
32
45

1

i spend alot of time using the debugger to figure out the fields . This is very useful :) – rockstar Mar 29 '13 at 11:31

score 6 · Answer 3 · edited May 11 '14 at 19:32

6

content://sms is not part of the official Android API, and as such it's not a good idea to use it. It may stop working, and some phones that use their own implementations for SMS (HTC Sense, maybe?) may have their own content provider that won't work with your code.

That said, if you really want to dig into it, you can look at the source code for it.

But again, heed this warning: http://android-developers.blogspot.com/2010/05/be-careful-with-content-providers.html.

edited May 11 '14 at 19:32

Sufian

6,405
16
66
120

answered Oct 26 '10 at 09:10

EboMike

76,846
14
164
167

2

what should be the preferred way of accessing the SMS store? Should we manually create the conversation lists? – Dennis Winter Oct 26 '10 at 11:38

Shwarz Andrei · Answer 4 · 2016-06-14T12:35:23.760

Just try this:

public void showAllCNames (View v){
        Uri uri = Uri.parse("content://sms/");
        final Cursor cur = getContentResolver().query(uri, null, null, null, null);
        for (String s : cur.getColumnNames()){Log.d("COLUMN_NAME", s);}
}

I ran through the column name and got it:

COLUMN_NAME: _id

COLUMN_NAME: thread_id

COLUMN_NAME: address

COLUMN_NAME: person

COLUMN_NAME: date

COLUMN_NAME: date_sent

COLUMN_NAME: sc_timestamp

COLUMN_NAME: protocol

COLUMN_NAME: read

COLUMN_NAME: status

COLUMN_NAME: type

COLUMN_NAME: reply_path_present

COLUMN_NAME: subject

COLUMN_NAME: body

COLUMN_NAME: service_center

COLUMN_NAME: locked

COLUMN_NAME: sub_id

COLUMN_NAME: error_code

COLUMN_NAME: seen

COLUMN_NAME: lgeMsgType

COLUMN_NAME: lgeSiid

COLUMN_NAME: lgeCreated

COLUMN_NAME: lgeExpires

COLUMN_NAME: lgeReceived

COLUMN_NAME: lgeAction

COLUMN_NAME: lgeSec

COLUMN_NAME: lgeMac

COLUMN_NAME: lgeDoc

COLUMN_NAME: doInstalled

COLUMN_NAME: lgePinRemainCnt

COLUMN_NAME: index_on_icc

COLUMN_NAME: service_msg_sender_address

COLUMN_NAME: lgeCallbackNumber

COLUMN_NAME: sms_imsi_data

score 0 · Answer 5 · answered Jul 11 '17 at 07:53

0

If you just want to know what is stored in particular cursor you can simply use DatabaseUtils.dumpCursor(cursor); to display all columns with values on your console

answered Jul 11 '17 at 07:53

Lau

1,804
1
23
49

score -1 · Answer 6 · answered Sep 20 '14 at 07:39

Android 4.4.2 phone Since this is version/content specific, do not rely on the numberic index key

_id thread_id address m_size person date date_sent protocol read status type reply_path_present subject body service_center locked sim_id error_code seen ipmsg_id

How many database columns associated with a SMS in android?

6 Answers6

Linked