Re: WITHOUT ROWID tables
| Newsgroups | gmane.comp.db.sqlite.general |
|---|---|
| Message-ID | <CAFkD5vtivmsBxcC057f0CaPUK-39M3-yv_=zX2RBB32wRf=N9g@mail.gmail.com> |
>
> To determine if table XYZ is a WITHOUT ROWID table, run "PRAGMA
> index_info('XYZ');". If you get back one or more rows, then XYZ is a
> WITHOUT ROWID table. If you get back no rows, then XYZ is a rowid
> table.
>
Confused...What if I made an index on a ROWID table?
CREATE INDEX "Z" ON "DOC" ("n_id");
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users