Purpose of using Pragma commands in SQLite

Question

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

Answer 1

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.