Hi, I didn't get a response to my first post to this group
and I didn't get a copy, so perhaps it didn't go through...
Is there any way to detect, based strictly on querying
the structure of a table/database whether there is an
AUTOINCREMENT set? That is to say, without
analyzing the original SQL creation statement, and
without inserting a new element into the database.
How is the difference between these two detectable?
CREATE Table myTab ('AUTOINCREMENT col' INTEGER AUTOINCREMENT PRIMARY KEY)
vs.
CREATE Table myTab ('AUTOINCREMENT col' INTEGER PRIMARY KEY)
I have not found a difference upon looking at:
SELECT * FROM sqlite_master WHERE type='table' AND name='myTab';
PRAGMA table_info('myTab');
The following is empty:
PRAGMA index_list('myTab');
so index_info does not seem relevant either.
Thanks,
Csaba Gabor from Vienna
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
