2008/2/21, Neville Franks <[EMAIL PROTECTED]>: > 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