Hi,
   
  
  1. with sqlite Is it possible to have a primary key made up of 2 fields? (If 
so how...)
  (from firebird:
  ALTER TABLE "table1" ADD CONSTRAINT PK_TABLE1 PRIMARY KEY 
("field1","field2");)
   
  
  2. Is it possible to add a primary key with an "ALTER" statement like:
  ALTER TABLE "table1" ADD CONSTRAINT PK_TABLE1 PRIMARY KEY ("field1");
   
  
  Thanks
  Rael

       
---------------------------------
Be a better friend, newshound, and know-it-all with Yahoo! Mobile.  Try it now.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to