On May 29, 2004, at 7:55 AM, Puneet Kishor wrote:
I believe that folks designing applications of any sort (and, it would seem that most users of SQLite on this list are application designers rather than just managers of data that happen to reside in SQLite) have a continuing and real need to easily determine the column types. If these types happen to include "constraints" and "default values," great, we want to know those also. While the info in sqlite_master does give the "schema," it is arguably a tad inconvenient to get at. Now I have learned that various PRAGMAs allow me to do just that. So, they should do it completely.
Yes, I do agree that I want to be able to find out everything about a column, including its type and *all* of its constraints. There is a way to do that now, except that you can't determine if a column is UNIQUE. I think I need that if I want to be able to implement my own ALTER, for example, on top of the SQLite library.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
