-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 05/15/2011 03:05 PM, romtek wrote: > I want to rename date to dateAdded. > > 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
Not exactly a large hoop. Also note the examples on SO should wrap the whole thing in a transaction. Wanting to rename a column should be a rare thing since it is so rare. If you are frequently renaming columns then your code will be very brittle. Also be aware that you can "rename" columns returned from selects. For example: SELECT id, eventName, date AS dateAdded FROM table .... Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) iEYEARECAAYFAk3QU2QACgkQmOOfHg372QRekQCgqfyRlFV/nXo7bXeMuQ6TZWxX +z8AoMNsx0MUToWvGzPg8b0Ju0GPevqq =floC -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
