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)
--
Igor Tandetnik

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to