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 Sqlite. Building few metatables like sqlite_foreing_keys, sqlite_columns would be the best. In this way it would be possible to list and the foreign keys over two or more columns. Also please have in view building sql commands like ALTER TABLE ... ADD CONSTRAINT ... FOREIGN KEY ( ... ) REFERENCES ( .... ) and ALTER TABLE DROP CONSTRAINT .... Best regards, Dragos Pruteanu _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users