On 1/5/2014 1:41 PM, Petite Abeille wrote:
On Jan 5, 2014, at 6:56 PM, Igor Tandetnik <i...@tandetnik.org> wrote:
On 1/4/2014 7:15 PM, Elrond wrote:
Short: Could you implement alter table rename column?
The problem would be, what to do with all the indexes, triggers, views and
foreign keys that reference that column?
Sure, but that’s an unrelated set of problems, isn’t it? As it stands, one
cannot even rename a column.
In SQLite, if you update just the CREATE TABLE statement but no other
parts of the schema, you may easily end up with a database that can't be
opened at all.
(P.S. Other DBs tend to simply invalidate all the related objects and let the
user sort it out)
If you are willing to let the user sort it out, then the existing
mechanism of directly manipulating sqlite_master should suffice.
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
