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); ?
