Partners
Download
BuySQLite Code Factory online Help
| Prev | Return to chapter overview | Next |
EXPLAIN
sql-statement ::= |
EXPLAIN sql-statement |
The EXPLAIN command modifier is a non-standard extension. The idea comes from a similar command found in PostgreSQL, but the operation is completely different.
If the EXPLAIN keyword appears before any other SQLite SQL command then instead of actually executing the command, the SQLite library will report back the sequence of virtual machine instructions it would have used to execute the command had the EXPLAIN keyword not been present. For additional information about virtual machine instructions see the architecture description or the documentation on available opcodes for the virtual machine.
| Prev | Return to chapter overview | Next |
