Hi,
I am new to the list and to Sqlite. Reading over the archive didn't
helped me much. It was only a 'flight' over the result searching for
'foreign'.
What I have captured is the ability to define fireign keys in the
tables and with the help of Cody Pisto creating the constraints as
triggers.
My question:
Is there an API function to get the foreign keys per table ?
Or must I use always the code from Cody to get the information ?
If there is no solution, is it possible to automate this by modifying
the CREATE TABLE code to trigger the code of Cody and hold the
information
in some 'system tables' (DROP TABLE could remove these informations
again) ?
Then the API could be extended by looking in these tables for foreign
keys, what would be reasonably fast.
Thanks, Lothar
--
Lothar Behrens | Rapid Prototyping ...
Heinrich-Scheufelen-Platz 2 |
73252 Lenningen | www.lollisoft.de
