On 15 May 2011, at 11:05pm, romtek wrote: > I will give you an example, and you correct my use of the terms, please. > > A table: > > id, eventName, date > > I want to rename date to dateAdded.
Okay, that's a column name, and you want the ability to rename columns. > People currently jump through hoops in order to achieve such a simple (from > the user's point of view) and needed goal: > http://stackoverflow.com/questions/805363/how-do-i-rename-a-column-in-a-sqlite-database-table > . 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. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
