Android Query SMS Database

Android Common database field description
1. SMS Database
String Struriinbox = "Content://sms";
Uri urisms = Uri.parse (Struriinbox);
Cursor c_groups = Managedquery (urisms, new string[] {"Date", "Person"}, select, NULL, "date DESC");
strcolumnname=_id strcolumnvalue=48//Short Message serial number
strcolumnname=thread_id strcolumnvalue=16//Conversation number (conversation)
strcolumnname=address strcolumnvalue=+8613411884805//Sender address, mobile number
Strcolumnname=person strcolumnvalue=null//sender, return a number is the ordinal of the contact list, the stranger is null
Strcolumnname=date strcolumnvalue=1256539465022//Date long type, get the exact date yourself convert it!
Strcolumnname=protocol strcolumnvalue=0//protocol
Strcolumnname=read strcolumnvalue=1//whether to read
Strcolumnname=status strcolumnvalue=-1//Status
Strcolumnname=type strcolumnvalue=1//Type 1 is received, 2 is emitted
Strcolumnname=reply_path_present strcolumnvalue=0//
Strcolumnname=subject strcolumnvalue=null//Theme
Strcolumnname=body strcolumnvalue= Hello//Short message content
Strcolumnname=service_center strcolumnvalue=+8613800755500//SMS Service center number, you can tell where the text is sent from the following table
2. Contact database
Strcolumnname = _sync_id Strcolumnvalue=null
Strcolumnname = Primary_organization Strcolumnvalue=null
Strcolumnname = Notes Strcolumnvalue=null
Strcolumnname = Primary_phone strcolumnvalue=1
Strcolumnname = Status Strcolumnvalue=null
Strcolumnname = Im_handle Strcolumnvalue=null
Strcolumnname = _sync_local_id Strcolumnvalue=null
Strcolumnname = Im_account Strcolumnvalue=null
Strcolumnname = _sync_time Strcolumnvalue=null
Strcolumnname = Im_protocol Strcolumnvalue=null
Strcolumnname = Mode Strcolumnvalue=null
strcolumnname = Label Strcolumnvalue=null
Strcolumnname = times_contacted strcolumnvalue=0
Strcolumnname = Name Strcolumnvalue=é?? È?3
Strcolumnname = Send_to_voicemail Strcolumnvalue=null
Strcolumnname = Primary_email Strcolumnvalue=null
Strcolumnname = Custom_ringtone Strcolumnvalue=null
Strcolumnname = Sort_string strcolumnvalue=í?¤í2?í?? Ío3à?
Strcolumnname = _sync_version Strcolumnvalue=null
Strcolumnname = last_time_contacted Strcolumnvalue=null
Strcolumnname = _sync_account Strcolumnvalue=null
Strcolumnname = Display_name strcolumnvalue=é?? È?3
Strcolumnname = Number_key strcolumnvalue=77681111831
Strcolumnname = number strcolumnvalue=13811118677
Strcolumnname = Phonetic_name Strcolumnvalue=null
Strcolumnname = _id strcolumnvalue=1
Strcolumnname = Type strcolumnvalue=2
Strcolumnname = _sync_dirty strcolumnvalue=1
Strcolumnname = Starred strcolumnvalue=0
4. Other databases
Available Uri String
Content://contacts/people//Local contact list information
Content://contacts/phones//Local contact list information
content://call_log/calls///Local Call log
Content://mms MMS
Content://mms-sms/threadid
Content://mms-sms/conversations
Content://mms-sms/messages/byphone
Content://mms-sms/undelivered
Content://mms-sms/draft

String Struriinbox = "Content://sms/inbox"; Sms_inbox:1
String strurifailed = "content://sms/failed"; Sms_failed:2
String struriqueued = "content://sms/queued"; Sms_queued:3
String strurisent = "Content://sms/sent"; Sms_sent:4
String Struridraft = "Content://sms/draft"; Sms_draft:5
String Strurioutbox = "Content://sms/outbox"; Sms_outbox:6
String struriundelivered = "content://sms/undelivered"; Sms_undelivered
String Struriall = "Content://sms/all"; Sms_all
String struriconversations= "Content://sms/conversations";//you can delete one conversation by thread_id
String Struriall = "Content://sms"//you can delete one message by _id

Android Query SMS database