Puneet Kishor wrote:
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.
I agree. I think there is at least one piece of information you can't get about a column, which is whether or not it is UNIQUE. I would really like to be able to recreate the SQL that was used to create a table without having to parse the CREATE TABLE SQL itself.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
