Sam Carleton <scarle...@miltonstreet.com> wrote: > In other databases there have been times when I have played some tricks with > the master tables, an example is: > > Goal: change some fundamental characteristics of 'target_table' which cannot > be done by an ALTER > > 1: Create the new table with a different name: target_table2 with the > changes > 2: Do an insert/select to insert the contents of target_table into > target_table2 > 3: Drop target_table > 4: Modify the master table to change the name of target_table2 to > target_table > > According to the FAQ, sqlite_master is read-only. Is there any to pull of > this trick?
Steps 1-3 just work. Step 4 can be done this way: alter table target_table2 rename to target_table; -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
