Re: [sqlite] Feature about Foreign Keys

2011-09-26 Thread Paul Linehan
> I would ask for a feature: to have a meta table where the foreign keys are > listed. > This feature it would be nice for large schemes. There are lots of nice-to-have features that one could add to SQLite. If you want to keep track of your foreign keys, download Datamodeler from Oracle -

Re: [sqlite] Feature about Foreign Keys

2011-09-26 Thread Petite Abeille
On Sep 26, 2011, at 3:19 PM, Pruteanu Dragos wrote: > I would ask for a feature: to have a meta table where the foreign keys are > listed. This is a popular request, but, for the time being, PRAGMA foreign_key_list is all SQLite has to offer:

[sqlite] Feature about Foreign Keys

2011-09-26 Thread Pruteanu Dragos
Hallo Sqlite, I would ask for a feature: to have a meta table where the foreign keys are listed. This feature it would be nice for large schemes. Implementing this in separate tables would allow other design tools to read the schema design, and have a more performant workenvironment with