On 11 Feb 2017, at 2:50pm, Rob van der sloot <robvandersl...@gmail.com> wrote:
> I want to use the index of a specific column of a table as a pulldown list > in my application. > But I can't find any syntax how to select or view an index. Sorry. There is no way to find the contents of an index. However, you can do SELECT on the column which was indexed using an ORDER BY clause. And SQLite will automatically use the index to do the SELECT in the fastest way. (Unless there are two of them !) Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
