On 26 Dec 2010, at 6:26pm, Drake Wilson wrote: > Quoth Norman Gray <nor...@astro.gla.ac.uk>, on 2010-12-26 18:14:23 +0000: >> The phrase "For each UNIQUE constraint on the table" appears to be >> redundant; if it's not, then that might need to be adjusted. > > A UNIQUE specifier on a column creates one UNIQUE constraint on > exactly that column. UNIQUE specifiers on multiple columns are > unrelated. You may specify a multi-column UNIQUE constraint by > declaring it separately (and not as part of any column specification).
... and to do that you create an index on that tuple, and require the index to enforce uniqueness: CREATE UNIQUE INDEX tab ON t (a,b) Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
