Fred Williams wrote:
I think what is being looked for here is information available from many commercial databases. There are elaborate "System" tables containing the entire database structure down to the finest detail including table formats, relationships, triggers, stored procedures, and etc. These tables are standard data tables, but normally protected from everyone but the DBA.
Exactly. Thanks for putting words to this. That would be very nice to have... a "system" table that contains the entire db structure to the extent it is present in SQLite.
That said, Will Leshner wrote: .. > What about a "PRAGMA table_info(table-name)" query?
I tried this just now and seems like this will also be very useful. Thanks Will.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
