Thanks for the reply. Yes, the table gets created, however the primary key
(sqlite_autoindex_tablename_1) if it is created, is not visible as a
distinct row in sqlite_master.
Are you saying that the index is created even if it is not added to
sqlite_master? If the answer is yes, then how could one find the primary key
for a table (preferably without parsing sqlite_master.SQL)?
As I understand it, sqlite always creates a row id:
read http://www.sqlite.org/version3.html "64-bit ROWIDs"
and http://www.sqlite.org/autoinc.html
There is no need to create a separate index for
INTEGER PRIMARY KEY, because that's the "natural order"
of the table.... Therefore that' the most efficient "index".
Michael
