foreign
Checks for foreign key violations in the database.
This pragma searches for rows in the database that have foreign key violations. If a table is specified, it only checks that table. If no table is specified, it checks all tables in the database.
It returns a cursor where each row represents a single foreign key violation. The columns are:
table: The name of the table containing the child row with the violation.rowid: The rowid of the child row.parent: The name of the parent table.fkid: An integer ID representing the foreign key constraint that was violated.
If there are no foreign key violations, the cursor will be empty.
Return
A KQLiteCursor containing rows describing any foreign key violations found.
Author
MOHAMMAD AZIM ANSARI
Parameters
The specific table to check for foreign key violations. If null (the default), all tables in the database are checked.