Not sure if I'm in the right area for my question, but I guess people here might know the answer to this.

I have the text message file from my iPhone copied on my desktop (I'm on a Mac).
If I open this file in Text Edit I can read all sms text files, even the ones I deleted.
If I open up the file in SQ lite, only the visible files are shown. The ones deleted seem to be hidden.

Since it's pretty hard to read text in Text Edit I would like to turn the parameter that tell SQ lite and my iPhone to hide the deleted files so that they are showing up and make them easier to read.

Just curious how to make it work.

Is there a way to change that status in the deleted messages?
But what parameter is doing this job and how do I change this with a sq command?