"Rajesh Nair" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Yes I am looking for something like that. > Can you explain "create table mytable (x, y, z, primary key(x, y));" > What it will do?
It will create a table with three columns and a compound primary key encompassing two of said columns. > can I specify x as integer and y as text ? Yes: create table mytable (x integer, y text, z whatever, primary key(x, y)); Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users