On Mon, Nov 15, 2010 at 02:56:47PM +0000, Oliver Peters scratched on the wall: > Jay A. Kreibich <j...@...> writes: > > > You can also live dangerously and set "PRAGMA writable_schema=1", > > allowing you to UPDATE the sqlite_master table directly. > > is this PRAGMA documented?
No, not on the website. It is considered a private PRAGMA. > What do I achieve by updating sqlite_master? The SQL in sqlite_master is the definitive table definition. It is re-parsed every time the database is open. This is how SQLite knows and understands the internal data structures of the database file. Changing column types is usually OK, but modifing sqlite_master makes it very easy to corrupt a database file. I would avoid it unless you're somewhat knowledgable of SQLite's internals and, of course, you're working on a backup copy of the database. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is important that you have it, but showing it to the wrong people has the tendency to make them feel uncomfortable." -- Angela Johnson _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
