> Hi, > > I'm a complete sql novice so please go easy :) > > I'm trying to create two queries so I can determine which of the keys > for a given sqlite3 table is the primary key and which keys are > foreign.
Hello, I did not fully review your question detail, but perhaps this may help. The MyJSQLView application can generate a table DDL definition which I pretty sure does properly identify primary & foreign keys for a table. Please see: http://code.google.com/p/myjsqlview/ Code--> source--> utilities--> TableDefinitionGenerator.createSQLiteTableDefinition() danap. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
