Effect of setting the foreign keys Pragma
I have used foreign keys in a database. What will be the effect of setting the Pragma foreign_keys as True or False.
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Pravin MorePosted Nov 25, 2011, 1:45 AM
hi Monika,
In SQLLITE ,Foreign key constraints are disabled by default for backwards compatibility issue, so we must be enable it separately for each database connection.
But it again depend on which SQLLITE release version you are using.
Thanks,
Pravin.