-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 01/02/13 02:12, Paul Sanderson wrote: > I will know the name of the index - I just need to check that it has > been created.
Just use pragma index_info on the index name. If it doesn't exist then you get no rows returned and if it does exist then you a row per column in the index. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) iEYEARECAAYFAlELmyUACgkQmOOfHg372QSkCwCgvIzw59DcPMytdRssRs37YPRB IUMAoKmyDMkKhdubaMqdmp/H9WLrkYAW =WCNM -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users