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