How about this:
'CREATE TABLE TwoPrimaryFields (primaryField1 TEXT NOT NULL, primaryField2 TEXT NOT NULL, someOtherField TEXT, PRIMARY KEY (primaryField1, primaryField2)) From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Andi Suhandi Sent: 30 March 2011 07:56 To: General Discussion of SQLite Database Subject: [sqlite] Primary Key Does anyone know how to create table that has 2 primary key fields ? example: id (integer) as primary key, name (var char) primary key, address (varchar) I try to use SQLite Explorer to change the field properties, but always got fail Regards Andi _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _____ No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1204 / Virus Database: 1498/3537 - Release Date: 03/29/11 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users