On Sun, May 15, 2011 at 5:22 PM, Simon Slavin <slav...@bigfraud.org> wrote:
> Yeah, you have to fake it by making a new table. You want support for more > ALTER TABLE variants. The proper way to do it would be to > > ALTER TABLE myTable ADD COLUMN dateAdded > UPDATE myTable SET dateAdded = date > ALTER TABLE myTable DROP COLUMN date > > And SQLite doesn't support the third command. Well, I'm sure it's on the > 'to do' list. If not, one of the devs can add it. > Yes, that is what I want. This will allow tool developers to add the ability to rename columns to their tools easily. SQLite Expert ( http://www.sqliteexpert.com/) and SQLite Maestro ( http://www.sqlmaestro.com/news/company/sqlite_maestro_11_3_released/) already support this. Now I want at least one web based tool to have this feature too. Adminer (http://www.adminer.org/) seems like a very good tool, but its developer has refused to add this feature because SQLite doesn't support an easy implementation of it. So, I hope this feature gets added to the to-do list if it's not on it yet. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
