Change Column name and type SQLITE

Question

I have already create the huge database in my application. Now, I have to update one column with name and size with programatically.

As per my research: - Add new column in table - Drop older column from table

I add new column but how to delete old column from table.

Can anybody help me ?

Thanks,

score 0 · Accepted Answer · answered Feb 14 '14 at 09:40

0

I think what you are trying to the is a pure SQL command. Take a look at:

answered Feb 14 '14 at 09:40

macroland

Drop Column query is not working on sqlite. – Nirmalsinh Rathod Feb 14 '14 at 09:45
Sorry! http://stackoverflow.com/questions/5938048/delete-column-from-sql-table – macroland Feb 14 '14 at 09:52
By the way, I use SQLite Manager as an add on to Thunderbird and it does a good job. Maybe worth looking at. – macroland Feb 14 '14 at 09:54
I have to go with your link steps to save data. Anyways its work for me. Thanks :) – Nirmalsinh Rathod Feb 14 '14 at 11:17

1 Answers1