Anyone familiar with the sms.db file?

When I snoop through SMS.db files with notepad. I notice a list of phone numbers in the first top section. Could someone tell me the purpose of why those phone numbers are list there consecutively?

also those number aren't in view when open with sql database brower

Hello,

These phone numbers are your contacts-phone-numbers that send you a text message. This sms.db file is a SQLite database.

I hope this information helps. If not let me know.

- Muzz

the numbers listed on the top? Should the numbers be there if there was no text messages placed with those numbers?

Usually you can see the delete message after the phone numbers. But the first top section of the sms.db opened in notepad has number listed consecutively and i have no understand why they're there.

You can open the file in an SQLite reader (there's a Firefox extension and there are several free SQLite editors). Or, if you're trying to understand the format on a byte-by-byte level, read something about the details of the format.