Re: [sqlite] Suppress auto index
On Wed, 9 Jan 2008 17:28:29 +0530, "Yuvaraj Athur Raghuvir" <[EMAIL PROTECTED]> wrote: >Hello, > >When I upload data from a file into a table, I see that >SQLite creates an auto index table. You didn't post your schema, so I have to guess a bit. I think you mean SQLite creates an index with the name sqlite_autoindex__1 index on one of your tables, not a new table. If your PRIMARY KEY is not defined as columnname INTEGER PRIMARY KEY, SQLite needs it to maintain yout primary key. Or perhaps you mean a sqlite_sequence table? That one is used to keep track of AUTOINCREMENT keys. >Is it possible to instruct SQLite not to create any auto >indices for the tables I create? If so, how? Change your schema. >Thanks and Regards, >Yuva HTH -- ( Kees Nuyt ) c[_] - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Suppress auto index
"Yuvaraj Athur Raghuvir" <[EMAIL PROTECTED]> wrote: > Hello, > > When I upload data from a file into a table, I see that SQLite creates an > auto index table. Is it possible to instruct SQLite not to create any auto > indices for the tables I create? If so, how? > Any PRIMARY KEY (other than an INTEGER PRIMARY KEY) and any UNIQUE constraint automatically generates an index. This cannot be suppressed. -- D. Richard Hipp <[EMAIL PROTECTED]> - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] Suppress auto index
Hello, When I upload data from a file into a table, I see that SQLite creates an auto index table. Is it possible to instruct SQLite not to create any auto indices for the tables I create? If so, how? Thanks and Regards, Yuva