Android Example SQLite Database Pragmas

Pragmas: table_info, index_list, index_info, foreign_key_list

The full list of pragmas can be found at: Note, the [match] field of the [foreign_key_list] pragma always shows "NONE" in the attached example. This value is incorrect - it should be "FULL". Either the pragma is faulty or the SQLite management program I am using is not storing the value correctly to the pragma.

TAGS: SQLite, PRAGMA, Database, table, index, foreign key


    323.1 KB · Views: 820
Last edited: