Hi, Will foreign key creation give me the speed increase? Or I need more an index?
Thank you. On Tue, Jan 1, 2013 at 10:01 AM, Peter Haworth <[email protected]> wrote: > And remembering that you will lose any indexes or triggers defined for the > table by doing this. > > There are plenty of third party tools out there that will take care of > adding/removing constraints to existing tables and a whole lot of other > functions that aren't available in SQLite's DDL, while accounting for all > their secondary effects. > > Pete > lcSQL Software <http://www.lcsql.com> > > > On Tue, Jan 1, 2013 at 9:00 AM, <[email protected]> wrote: > >> Message: 1 >> Date: Mon, 31 Dec 2012 10:13:40 -0800 >> From: Ward Willats <[email protected]> >> To: General Discussion of SQLite Database <[email protected]> >> Subject: Re: [sqlite] Is there a way to create a foreign key in >> existing table? >> Message-ID: <[email protected]> >> Content-Type: text/plain; charset=us-ascii >> >> >> >> Or, if you want to do it "live:" use ALTER TABLE to rename the existing >> table, CREATE TABLE to make the table with the FK you want, INSERT SELECT >> to bring the records from the renamed table to the new table, and DROP >> TABLE to get rid of the renamed original. >> > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
