Noël Frankinet wrote: >Is there a better way to list all table making a view than parsing SQL. >Is there an API ? >I would like to show all table in a view (in a tree-view gadget). >Same question for the table schema, I do parse the SQL but its rather >fragile.
I am having a bit of difficulty understanding your question, but get the impression your parsing the DDL that created the table. If I am right you will want to look at the PRAGMA statements to query the database schema. Kind regards Hans -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.322 / Virus Database: 266.11.17 - Release Date: 5/25/2005