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
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
Last edited:
