Become a MacRumors Supporter for $25/year with no ads, private forums, and more!


macrumors newbie
Original poster
Sep 20, 2017
So I have deleted some SMS that were very important to me by accident. I found the sms.db file, and opened it in Notepad. There were a lot of symbols, and the texts were all over the place. I did notice some of my deleted texts in the document, but it was very unclear as to when I sent the messages or to whom they were sent. So, I wanted to find a clearer way to view the messages. SQLite Studio has helped, but I can only view the messages that I haven't deleted. I've tried to create a query for the deleted messages tab, but nothing comes up. Does anyone know of any program that can help me recover those missing messages? It's so weird that notepad shows them, but not sqlite.

Also, I am very new to this, so please explain in easy terms :p Thanks
Last edited:
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.