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? can I specify x as integer and y as text ?
On Thu, Dec 11, 2008 at 6:06 PM, Igor Tandetnik <[EMAIL PROTECTED]> wrote: > "Rajesh Nair" <[EMAIL PROTECTED]> > wrote in message > news:[EMAIL PROTECTED]<[EMAIL PROTECTED]> > > Can I define a combination-key in sqlite. If yes, how? > > Sqlite is allowing me to declare more than one PRIMARY KEY. > > I'm not sure I understand the question, but are you perhaps looking for > something like > > create table mytable (x, y, z, primary key(x, y)); > > Igor Tandetnik > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Regards Rajesh Nair _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users