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.
Consider:
CREATE Table myTab (col1 INTEGER AUTOINCREMENT PRIMARY KEY)
vs.
CREATE Table myTab (col1 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.
Am I missing something? Thanks,
Csaba Gabor from Vienna
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
