[sqlite] Foreign Key constraint checking

Hello,

 

I am well aware that SQLite doesn't enforce FK's and that a way around
this is to use triggers.  This lack of enforcing actually has worked to
my advantage as when populating my database I can insert data out of
order.  However, after all data has been inserted into the database, I'd
like to perform some constraint checking to ensure that any FK column
value correctly matches a row that the FK references.  Is there any
built-in methods or code snippits I can use for this or will I just have
to roll my own?

 

-Shaun

_______________________________________________
sqlite-users mailing list
sqlite-users@xxxxxxxxxx
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users