Is there way to add non-unique columns in a unique index? I would like to use the same index to enforce unique constraints, as well as giving a covered result for other queries.
Something like an 'INCLUDE' would also work (actually even better). E.g. CREATE UNIQUE INDEX indx ON Foo(UniqueCol) INCLUDE (ExtraCol) If not, is there a way to efficiently implement a UNIQUE constraint in a different way? (Trigger maybe?) -Deon _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
