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

Reply via email to