Keith Roberts <[email protected]> wrote: > I think what I really mean is I want a text column with only > one unique value, that is also indexed.
UNIQUE constraint will do just that. > Also ,I guess the INTEGER PRIMARY KEY column is worth > keeping in the table, as a matter of course? Usually, yes. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

