Re: [sqlite] Suppress auto index

[Kees Nuyt]

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

[drh]

"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]
-