Cannot delete column from sqlite table [Android]

Question

Since I cannot comment here : How do I delete column from sqlite table in android?

I do the method and not work at all, the column is still exist. Here's my SQL :

db.execSQL("CREATE TEMPORARY TABLE Evaluation_backup(" + allColumnName + ");" 
                    + "INSERT INTO Evaluation_backup SELECT " + allColumnName + " FROM Evaluation;"
                    + "DROP TABLE Evaluation;" 
                    + "CREATE TABLE Evaluation("+ allColumnName + ");" 
                    + "INSERT INTO Evaluation SELECT " + allColumnName + " FROM Evaluation_backup;"
                    + "DROP TABLE Evaluation_backup;");

The allColumnName is String contains all the column names except the name of the column that I want to remove. The allColumnName content like this: column1,column2,column3.

Thanks in advance.

I have checked the string 'allColumnName'. My table still exist with the all column (I didn't knew the table was created or this SQL not worked). By the way, I have successfully added new column in the table. — andrefadila
– andrefadila, Commented Aug 7, 2013 at 6:30
try to delete the last line then check the content of Evaluation backup — Hossam Oukli
– Hossam Oukli, Commented Aug 7, 2013 at 6:37

CL. · Accepted Answer · 2013-08-07 06:51:00Z

6

The documentation for execSql says:

Execute a single SQL statement …

Call db.execSql once for each statement.

answered Aug 7, 2013 at 6:51

CL.

182k18 gold badges241 silver badges282 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

andrefadila Over a year ago

Yeah it's worked, thanks master @CL. :D and I feel sorry for the documentation :(

Collectives™ on Stack Overflow

Cannot delete column from sqlite table [Android]

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related