C++ and Sqlite DELETE query doesn`t actually delete the value from the database file

I`ve came accross this issue on SQlite and c++ and i can't find any answer on it.

Everything is working fine in SQlite and c++ all queries all outputs all functions but i have this question that can`t find any solution around it.

I create a database MyTest.db I create a table test with an id and a name as fields I enter 2 values to each id=1 name=Name1 and id=2 name=Name2 I delete the 2nd value

The data inside table now says that i have only the id=1 with name=Name1

When i open my Mytest.db with notepad.exe the values that i have deleted such as id=2 name=Name2 are still inside the database file though that it doesn`t come to the data results of this table but still exists though.

What i like to ask from anyone that knows about it is this : Is there any other way that the value has to be deleted also from the database file or is it my mistake with the DELETE option of SQLITE (that i doubt it)

Its like the database file keeps collecting all the trash inside it without removing DELETED values from its tables...

Any help or suggestion is much appreciated