Page 1 of 1

Adding multiple primary keys to existing table

Posted: May 24th, 2022, 3:01 pm
by btyrell
I am trying to add 2 primary keys to an existing table. However, both columns are not unique on their own, so when I try to add either as a primary key I get a primary key error from SQL.

In SSMS, this could be fixed by adding both primary keys at the same time. Is this possible from the IDE?

Re: Adding multiple primary keys to existing table

Posted: May 25th, 2022, 4:21 pm
by SteveCap
Currently would only be possible if the table was empty since we only allow editing of one column at a time. I have created task #10477 to review this.