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
