Purpose of using Pragma commands in SQLite

Question

Why we use Pragma commands in SQLite. What is its basic use

Aarti · Answer

Hi Monika The PRAGMA command is used to modify the operation of the SQLite library. The pragma command is experimental and specific pragma statements may be removed or added in future releases of SQLite. for example PRAGMA integrity_check; The command does an integrity check of the entire database. It looks for out-of-order records missing pages malformed records and corrupt indices. If any problems are found then a single string is returned which is a description of all problems. If everything is in order ok is returned. Thanks. If it help plz mark it as answer.