There's no ALTER COLUMN in sqlite.

I believe the option is to:

•Rename the table to a temporary name
•Create a new table without the NOT NULL constraint
•Copy the content of the old table to the new one
•Remove the old table

Can you guys implement ALTER COLUMN in sqlite? it would be a great feature.



--
View this message in context: 
http://sqlite.1065341.n5.nabble.com/ALTER-COLUMN-in-sqlite-tp71706.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to