On May 29, 2004, at 7:31 AM, Tito Ciuro wrote:
SQLite stores the original SQL statement that created the table. This statement can be retrieved, as you well suggested, querying sqlite_master. The data is there, but SQLite doesn't do its homework when PRAGMA show_datatypes = ON is set. Instead of reporting in the result set that x is a INTEGER PRIMARY KEY, it returns INTEGER and chops out the rest.
Personally, I don't think of PRIMARY KEY as part of the type. I think of it as a constraint. I'm not sure I want to have to distinguish between INTEGER and INTEGER PRIMARY KEY as types. They are both INTEGER. I think if SQLite reported an INTEGER column as INTEGER PRIMARY KEY, then I would have more work to do to recover the actual type.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
