Tom Parke <[EMAIL PROTECTED]> wrote:
I created a table with column 1 as primary key. So where are the index records?
In the database, of course.
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.
This table stores statistics, not indexes. See ANALYZE statement.
And, do primary keys need to be the first consecutive n fields?
No.
I couldn't have a table with only column 3 as primary key could I?
You could. Igor Tandetnik ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------