Hello ! Does anybody knows how to rename a table and all it's dependencies in one go ?
? The problem: a database has several tables and views that reference/use other tables something simplified like this: ======== CREATE TABLE a(id integer primary key, name text); CREATE TABLE b(id integer primary key, a_id integer references a(id), name text); CREATE VIEW aview AS select * from a; CREATE VIEW bview AS select b.*, a.name from b left join a on b.a_id =aid; ======= ? Now if we do "alter table a rename to a2;" actually sqlite only rename the "a" all foreign key references from "a" to "a2" but leaves all views broken. =======schema after "alter table a rename to a2;" CREATE TABLE "a2"(id integer primary key, name text); CREATE TABLE b(id integer primary key, a_id integer references "a2"(id), name text); CREATE VIEW aview AS select * from a; CREATE VIEW bview AS select b.*, a.name from b left join a on b.a_id =aid; ======= Is this a bug ? Cheers ! ?
