Cannot delete column from sqlite table [Android]
android, sqlite
Solution
The documentation for `execSql` says:
Execute a single SQL statement …
Call `db.execSql` once for each statement.
Problem
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.