getting error when add column to table

[mmccaws2]

Hi

I don't understand the error for this statement for SQLITE

$dbh->do("ALTER TABLE new_definition (
        ADD COLUMN loopback TEXT)");

here is the error message:

DBD::SQLite::db do failed: near "(": syntax error(1) at dbdimp.c line
271 at ./a
ddnewdef.pl line 38.
DBD::SQLite::db do failed: near "(": syntax error(1) at dbdimp.c line
271 at ./a
ddnewdef.pl line 38.

Or is it the case I'll have to delete the table and create the table
with the new column added.




Also additional question about SQLITE.  I've been developing using
against a SQLITE db.  I trimmed hundreds of entries out of table and
the count command returns values shows that the number of entries has
reduced.  However the file doesn't reduce in size.  Does SQLITE keep
the last greatest  file size eventhough the table has been trimmed?
Or is there something else I need to do.

Thanks

Mike