"Gregor Brandt" <[email protected]> wrote in message news:[email protected] > If I call CREATE INDEX on an existing table will the index be > automatically updated if the table is altered
Yes. > 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. You use CREATE INDEX statement without UNIQUE keyword to create a non-unique index on this column. Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
