D. Richard Hipp wrote:
Puneet Kishor wrote:
Also, afaik, there doesn't seem to be any "easy" facility to reconstruct the schema...
The schema is exactly reconstructed as follows:
SELECT sql FROM sqlite_master WHERE sql NOT NULL;
I guess I didn't phrase that properly. What I have been looking for is a way to return a list of columns (names, types, defaults, etc.). As I said, I accomplished it by a kludgy method -- taking the schema and extracting the column info from it. One possible way to make this easier would be to actually have an alternate "schema table" with such information in it for every table. That way one would query _that_ alternate "schema table," and instead of getting the SQL statement used to form a given table, one would get the name, the columns, and all manner of info about those columns.
Thanks to all.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
