Pragma statements supported by SQLite

PRAGMA Statements

The PRAGMA statement is an SQL extension specific to SQLite and used to modify the operation of the SQLite library or to query the SQLite library for internal (non-table) data. The PRAGMA statement is issued using the same interface as other SQLite commands (e.g. SELECT, INSERT) but is different in the following important respects:

• Specific pragma statements may be removed and others added in future releases of SQLite. There is no guarantee of backwards compatibility.
• No error messages are generated if an unknown pragma is issued. Unknown pragmas are simply ignored. This means if there is a typo in a pragma statement the library does not inform the user of the fact.
• Some pragmas take effect during the SQL compilation stage, not the execution stage. This means if using the C-language 登录查看完整内容