Ah, yes they both work and tell me the indexed fields. Saves me some work parsing this out from the table create SQL. Thanks for that.
RBS On Thu, Dec 10, 2015 at 10:19 AM, Simon Slavin <slavins at bigfraud.org> wrote: > > On 10 Dec 2015, at 10:17am, Bart Smissaert <bart.smissaert at gmail.com> > wrote: > > > This will show in sqlite_master like this: > > > > type name tbl_name rootpage sql > > > --------------------------------------------------------------------------- > > index sqlite_autoindex_dataset_1 dataset 717 > > > > So, no SQL. Problem with this is that there is no way to see what fields > > the index is on. > > What happens if you do either of > > PRAGMA index_info(sqlite_autoindex_dataset_1); > PRAGMA index_xinfo(sqlite_autoindex_dataset_1); > > ? > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >
