PDA

View Full Version : Problem regarding SQLITE commands



sudheer168
18th December 2008, 07:58
Hi,
I am using QT4.4.0 and SQLITE as database. I am facing two problems regarding with SQLITE command.
1) I need to change the column name it means I want to rename the column name of a table.
2) If I delete some 100 rows from the table then they are deleting but the memory allocated to those row are not getting free , I mean the space allocated to those rows should be get free.
So Please suggest or help me to solve these problems.

With regards,
Sudheer

wysota
18th December 2008, 09:09
What memory doesn't get freed? If you mean the database itself then this is quite normal, moving all data after each row delete is too expensive and databases tend to leave it for some undefined moment in future when someone tells them to do that (like using the VACUUM command). As for the first problem simply execute a proper ALTER statement.