I will know the name of the index - I just need to check that it has been created.
On 1 February 2013 00:09, Simon Slavin <slav...@bigfraud.org> wrote: > > On 31 Jan 2013, at 10:57pm, Igor Tandetnik <i...@tandetnik.org> wrote: > > > On 1/31/2013 5:45 PM, Paul Sanderson wrote: > >> Is it possible to ascertain if an index on a particular column has > already > >> been created. > > > > PRAGMA index_list(YourTable), then for each index, PRAGMA > index_info(IndexName) > > But note that one index can be on any number of columns. In fact if you > have long SELECT statements you probably have long indexes too. So do you > want to know if you have an index on just that one column, or if you have > any indexes which include that column ? > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users