[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sqlite-users
Subject:    Re: [sqlite] Is there always an index on ROWID?
From:       "Jos van den Oever" <jvdoever () gmail ! com>
Date:       2008-02-21 7:39:23
Message-ID: c2dbc4260802202339i429f59d1ic86514d8ad1fb098 () mail ! gmail ! com
[Download RAW message or body]

2008/2/21, Neville Franks <sqlite@surfulater.com>:
>  If I create a table with a Primary key on a TEXT clm, will there still
>  be an Index on the in-built ROWID clm. The reason for asking this is
>  that I need fast (indexed) lookup to rows by both ROWID and my TEXT
>  clm.

According to the documentation for 'CREATE TABLE' [1] you can even use
a custom name for ROWID by specifying:
 CREATE TABLE X(ID INTEGER PRIMARY KEY NOT NULL, CONTENT TEXT);

[1] http://www.sqlite.org/lang_createtable.html
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[prev in list] [next in list] [prev in thread] [next in thread]