Your
table has a primary key yet, so you can´t add a second primary key. You
only can define one pk, however it can be composed as your table has (it now has
2 columns), so I think you need to drop the current pk and add again the new pk
with your 3 columns (probeid, tissueid, expid).
Rev
On Thu, 23 Feb 2006, Daniel Joo wrote:
> I am trying to add another primary key to an existing table with two
> other primary keys. I got the following error when I tried this
> command:
You only can have one primary key. The table you gave has a single
primary key with two columns. Are you tr