Android Example SQLite Database Pragmas

Pragmas: table_info, index_list, index_info, foreign_key_list

The full list of pragmas can be found at: http://www.sqlite.org/pragma.html. 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
 

Attachments

  • DBPragmas.zip
    323.1 KB · Views: 882
Last edited:
Top