I created a table with column 1 as primary key. So where are the index records? I thought I would find them in the sqlite_stat1 table but after inserting records in my table, there are no records in the sqlite_stat1 table.
And, do primary keys need to be the first consecutive n fields? I couldn't have a table with only column 3 as primary key could I? Tom