If I call CREATE INDEX on an existing table will the index be automatically updated if the table is altered or do i have to create the index again, will this occur between runs? I also notice that CREATE INDEX optionally takes a UNIQUE keyword. If I create a table from scratch how do I define the column so that it is an index but not UNIQUE.
Thanks Gregor _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
