cheeaun/gist:93816

Created April 12, 2009 01:38

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/cheeaun/93816.js"></script>
Save cheeaun/93816 to your computer and use it in GitHub Desktop.

Download ZIP

Change column name in SQLite

Raw

gistfile1.sql

	ALTER TABLE table ADD newColumn INTEGER;
	UPDATE table SET newColumn = oldColumn;

ssatyamchauhan commented Apr 16, 2019

it is not working post syntax for rename the column name in tables

krunalpatel3 commented Sep 24, 2019 •

edited

you need to upgrade sqllite database version to 3.29.0.

https://www.sqlite.org/android/doc/trunk/www/install.wiki
https://sqlite.org/lang_altertable.html
https://www.sqlite.org/download.html

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment