On Mon, Jul 23, 2012 at 8:35 AM, Arbol One <arbol...@gmail.com> wrote: > When using the statement 'UNIQUE INTEGER val', does SQLite3 automatically > create a unique integer value for the transaction or would it only > ascertain the uniqueness within that column? > > > > i.e.: > > Glib::ustring sql_param_tblName = "CREATE TABLE name(n_id INTEGER PRIMARY > KEY, title TEXT, fname TEXT, mname TEXT, lname TEXT)"; > > [I understand that UNIQUE is implied in PRIMARY KEY?] >
unique creates a unique index -- there must not be any duplicates in those columns used in the key. it doesn't do anything to affect transactions. primary keys are unique, yes. -- Cory Nelson http://int64.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
