(oops glitched my send) Try using a database modeling program such as
TMS Software's Data Modeler or SQL Maestro Group's SQLite Maestro These handle the changes nicely. You use the programs for designing your databases, queries, views and such. It spits out SQL to run on your system that handles setting up and changes. Or you can connect directly to your SQLite database and it will handle making all the changes for you. ------------ Scott Doctor scott at scottdoctor.com ------------------ On 8/21/2015 11:54 AM, Scott Doctor wrote: > > ------------ > Scott Doctor > scott at scottdoctor.com > ------------------ > > On 8/21/2015 10:37 AM, sqlite-mail wrote: >> Thanks for your attention! >> >> Only to remark on this I tested on postgresql and somehow it >> knows how deal >> with it ! "so few (none?)" >> >> Cheers ! >> >>> Fri Aug 21 2015 19:08:58 CEST from "J Decker" >>> <d3ck0r at gmail.com> Subject: >>> Re: [sqlite] Is this a bug ? How to rename a table and all >>> dependencies ? >>> >>> On Fri, Aug 21, 2015 at 10:04 AM, sqlite-mail >>> <sqlite-mail at dev.dadbiz.es> >>> wrote: >>>> Then do you think this is a bug ? >>>>> Fri Aug 21 2015 18:57:33 CEST from "Simon Slavin" >>>>> <slavins at bigfraud.org> >>>>> Subject: Re: [sqlite] Is this a bug ? How to rename a >>>>> table and all >>>>> dependencies ? >>> while it may be considered a nice thing; it's not common >>> practice to >>> rename tables, so few (none?) sql implementations >>> automatically update >>> references to tables when they are renamed. Not a bug; more >>> like out >>> of scope. >>> >>> It wouldn't know if you were moving a source table for archival >>> purposes and going to replace it with another empty one or >>> moving >>> because you didn't like your original schema. >>> >>>>> On 21 Aug 2015, at 12:20pm, sqlite-mail >>>>> <sqlite-mail at dev.dadbiz.es> wrote: >>>>> >>>>> >>>>>> Does anybody knows how to rename a table and all it's >>>>>> dependencies in one >>>>>> go >>>>>> ? >>>>>> >>>>>> >>>>> Can't be done. Sorry. >>>>> >>>>> Simon. >>>>> _______________________________________________ >>>>> sqlite-users mailing list >>>>> sqlite-users at mailinglists.sqlite.org >>>>> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>> _______________________________________________ >>>> sqlite-users mailing list >>>> sqlite-users at mailinglists.sqlite.org >>>> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >>>> >>> _______________________________________________ >>> sqlite-users mailing list >>> sqlite-users at mailinglists.sqlite.org >>> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >>> >>> >>> >> >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users at mailinglists.sqlite.org >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >> > > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > >
