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? Sam _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users