Re: [SQL] how to add primary key to existing table with multiple primary keys

2006-03-01 Thread Mauricio Fernandez A.
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

Re: [SQL] how to add primary key to existing table with multiple

2006-02-28 Thread Stephan Szabo
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