Will, 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)? Regards, Bogdan