View the structure of the underlying contact table in the androidcontacts operation series

View the structure of the underlying contact table in the androidcontacts operation series

For many kids who want to do the address book or want to operate the system address book, they will certainly encounter a problem. It is very troublesome to operate the system address book. Can I directly look at the underlying contact table structure?
?

If you can see it, it will certainly improve the accuracy and efficiency of related operations.

Not to mention, directly list the steps:

1. Open eclipse and run the simulator.

2. Call file explorer in Android (Windows-> show
View-> Other-> Android-> file Explorer)

3. Open File
Explorer, select data> DATA> com. Android. providers. Contacts> databases,
Now you can see a database: contacts2.db.

 

4. Click file.
"<-" In the upper-right corner of Explorer -"
Export the key to move contacts2.db to the custom location. Export the data to the root directory of drive D:

 

Export key

 

 

Save files

 

5. Download The SQLite management tool sqlitedev344. You can search Baidu and Google. I downloaded it from here (http://www.cr173.com/soft/12286.html)

6. Normal installation. Open

 

 

7. Click "+ Database" or
Database> Register a database

 

8. Select the exported database. The database alias can be used at will:

 

9. Open the left menu and double-click the contacts2 database.

 

 

 

 

10,
Select a table and you will see that all the tables in contacts are in your hands.

 

11,
Double-click the data table to view the table structure.

 

 

12,
Click
Data, View table content

 

 

 

13. Congratulations, you can view any table structure and data in contacts.

 

14. You will have time to post some contact operations.ArticleIf you have any questions, leave a message to discuss them.