Adding multiple primary keys to existing table

This forum allows users to post and respond to "How Do I Do ....." questions. The information contained in this forum has not been validated by K-Rise Systems and, as such, K-Rise Systems cannot guarantee the accuracy of the information.
Post Reply
btyrell
Posts: 29
Joined: September 8th, 2021, 2:59 pm
Contact:
Contact btyrell

Adding multiple primary keys to existing table

Unread post 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?
word count: 61
Tags:
database
primary-key
table
Top
SteveCap
Posts: 327
Joined: August 26th, 2021, 9:18 am
Contact:
Contact SteveCap

Re: Adding multiple primary keys to existing table

Unread post 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.
word count: 29
Top
Post Reply

Return to “General Forum”